Form Level Validation

[Jason Buck]

W/ACCESS 2002

I have a form that has a chkbx (chkRNW_CMPLT) if this is
clicked I need to require txtRNWL_CMPLT_DT is populated
with a date. If the chkbx is not complete (i.e. not
clicked) I don't want the txtRNWL_CMPLT_DT to be required.

Thanks for the help so far... Can you help me out on this
one?

Jason Buck

 

[Allen Browne]

You can do this at the engine level.

1. Open the table in design view.

2. Open the Properties box (View menu).

3. Locate the Validation Rule in the proeprties box (not the one in the
lower pane, which relates to a field.)

4. Enter:
([RNWL-CMPLT_DT] Is Not Null) OR ([MyYesNo] = False)

The rule is satisifed if the date is not null, or if the yes/no field is
unchecked.