Required Field.

[Guest]

Hi. I have a question about adding a required field or validation rule. I
have a access db already set up. on the form where you enter the info there
are drop down menus to select certain criteria instead of having to input
them. I want to have one the drop down menus be required to be filled out
before you can save or exit the form.

So, Basically if you don't select anything and try and exit or save it will
tell you that you need to fill this out action out first.

Thanks for any help.

 

[Guest]

Use the form's Before Insert event.
Test the control to see if it has value other than Null. If it is Null,
cancel the event and present the user a message box.