I have a form based on a table. The table contains several fields that have "required" data. The controls on the form allow users to enter the data. The form also allows the user to change to another record.
If the user enters some data and then moves to another record before filling in all "required" data, Access displays a message indicating that data in a field is missing but the message is cryptic/meaningless to a user.
I would like to trap the event gracefully and display a message to alert the user to "required" fields that do not yet have data entered, ie. an event that is triggered on an attempt to change a record. None of the "Form events" seem to do this, or am I missing something?
If the user enters some data and then moves to another record before filling in all "required" data, Access displays a message indicating that data in a field is missing but the message is cryptic/meaningless to a user.
I would like to trap the event gracefully and display a message to alert the user to "required" fields that do not yet have data entered, ie. an event that is triggered on an attempt to change a record. None of the "Form events" seem to do this, or am I missing something?