If Checkbox is ticked, Data Must be entered

[DTK0902]

Hi all,


Just another quick question, working through validation rules etc at the minute on my database. Have come across this one is sort of stumping me. I have a tick box in the field "Medication to be repeated" the next field after it is "Date to be repeated on". I am looking a validation rule which makes it that if the checkbox is ticked then date to be repeated must contain a valid date value.

Regards,
Daniel

[June7]

Don't think can have an IIf conditional expression in ValidationRule. Need to handle with code in an event. Probably VBA, don't know if macro can handle.

[DTK0902]

Thanks June7 will do a bit of research into it, bound to have a book in work somewhere on VBA.

[June7]

This thread suggests some references for VBA https://www.accessforums.net/program...hen-30362.html

[pbaldy]

I'd use the form's before update event:

http://www.baldyweb.com/BeforeUpdate.htm

In your case, you'd only test the date field if the checkbox is true.

[DTK0902]

Hi all and thanks for your replies. Managed to do a bit of Googleing and find that this can be validated by using a Record Validation Rule, a lot simpler than I first thought. Tested it and it works a charm.

Thanks,
Daniel

[June7]

Learn something new everyday. Never heard of Record Validation Rule. Is this in a Data Macro?

[DTK0902]

If you view your table in Datasheet View, and select the field you want to apply the record validation rule to, two tabs should appear along the top row like in the picture below. Then select record data validation. Its pretty simple, below is my rule for in-date not before D.O.B.

Regards,
Daniel

[June7]

Interesting feature, wonder if I can use it somewhere.

Also accessible from the Design view property sheet.