Required entry if check box is blank

[justair07]

Hello,

I have a lot of fields that I want to make required entry only if one of the check boxes I have is blank. If the check box is blank then I don't want any entries to be required.

For example, I have a form that needs to be filled out only if a machine is running, if the machine is not running then only certain fields need to be filled out and the user will select the check box labeled "Machine not running".

BTW, I'm very new to Access and have no experience with implementing code, other than with excel.

Thank you,



-justair

[pbaldy]

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

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

In your case, tests of the controls would be inside a test of the check box.

[justair07]

I'm completely lost on how to do this, please forgive my ignorance, but it sounds like i need to add code in the vb window?

[pbaldy]

Yes:

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

[justair07]

ok, thank you for the help!!

[pbaldy]

No problem, post back if you get stuck.