require field to have a value before closing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that requires a field to be filled out. I cannot figure out
the best way to alert a user to fill in the field and prohibit the form from
closing until that field has data. How do I do that?
 
On the before update event of the form you can write the code

If isnull(Me.FieldName) then
msgbox "Must fill field"
cancel = true ' wont let exit the form
Me.FieldName.setFocus
End IF
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

not allow data in sub-subform until subform field has data 1
When try to delete record, required field can't be null 3
required field in form 3
Test form for changes on close 6
check box with required fields 3
Required Field 1
Required field on form 0
Form Required Field 1

Back
Top