Help! Data Entry criteria Msg Box

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

Guest

I have designed a database which is used by lots of people. I know there is
a option in field properties set data entry to yes. But users are not able to
understand the msg that appears if they dont enter in a field.

If someone has not filled in a text box then a messege box sould come up
asking to complete data before going to the next record. Other wise click
exit.

Please Help!
 
Put VBA code to check the fields in the Before Update. If any fields are
missing, or if data is wrong, issue your own MsgBox, and set the Cancel
argument to True before exiting the procedure. That will inform the user,
cancel the update, and put the user back on the form.

I presume that by "users are not able to understand the msg that appears if
you don't...". you mean the default error message if you don't have error
handling, but have made that a mandatory field in the table definitions.

Larry Linson
Microsoft Access MVP
 
Back
Top