Macro that requires specific fields to be filled.

[mnsemple83]

I'm tryint to create a macro that will not allow the user to leave a form until they have completed all required fields. Any suggestions?

[pbaldy]

I'm not a macro user, but that type of thing is typically done in the before update event of the form:

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

[mnsemple83]

Well, my form is bound to a table and what I want is the user to be required to answer the first two questions and if one of them is unanswered and the user tries to move on to the next record via clicking a button, a message will display informing the user that the first two questions must be answered.

[pbaldy]

Yes, I know. Did you read the link?

[mnsemple83]

Yes, I read the link and I figured it out. Thanks.

[pbaldy]

Glad it helped.