| | |
|
|
|
Validation Rule |
|---|
| message from nl on 28 May 2004 |
How can I create a validation rule in a table,
example
Table name: ccgc
Field name: Status
Field name: Discont.
In the field name: Discont, I want to put a validation
rule: If field name: Status = 2, then you need to enter
information; if Status is not 2, then leave it blank.
Thank you.
|
| =?Utf-8?B?VGFzaGE=?= replied to nl on 28 May 2004 |
It might be best to do this on a form in the AfterUpdate event of a status field control. Something like
if me.status =2 then
me.discont.visible = true
else
me.discont.visible = false
end if
this will hide the discont field unless status = 2.
Do you want the field to be required if status = 2?
(This code has not been tested)
|
|
Archived message: Validation Rule (MS Access Database)
