Required field ... but only with certain information

[Guest]

I have a boolean command to enable some fields based on the result of an
option in a combo box.

Although the "required" property is set to "no", how can I ensure these
fields have been filled in (or changed) before the record is saved.

Cheers!

 

[Jeff Boyce]

Use a form. Use the form's BeforeUpdate event to verify/validate any
controls' values.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Guest]

thanks.

I was thinking of "exit" or "lost focus".

 

[Jamie Collins]

Although the "required" property is set to "no", how can I ensure these
fields have been filled in (or changed) before the record is saved.

Stating the obvious here but what about changing the "required"
property to "yes" and creating validation rules to test the "certain
information" is present.

Jamie.

--