G
George Papadopoulos
Hello everybody
I have built a form with some VBA code behind it. The form has some text
boxes which are bounded to fields on a database. Some error handling code
has been written so the form is rather error-safe.
One problem persists though. I would like to keep the record navigator
toolbar on the form. Sometimes, the user inputs data only partially on the
form. So if he/she presses a button on the record navigator, so as to move
to a previous or new record, the action fails with an error that not all
required fields have been entered.
How can I capture this error? I would like to be able to check if all
required fields have been entered before Access tries to commit the data. If
not all required fields have been entered I would like Access not to try to
move to a previous or new record.
thx, in advance
George Papadopoulos
I have built a form with some VBA code behind it. The form has some text
boxes which are bounded to fields on a database. Some error handling code
has been written so the form is rather error-safe.
One problem persists though. I would like to keep the record navigator
toolbar on the form. Sometimes, the user inputs data only partially on the
form. So if he/she presses a button on the record navigator, so as to move
to a previous or new record, the action fails with an error that not all
required fields have been entered.
How can I capture this error? I would like to be able to check if all
required fields have been entered before Access tries to commit the data. If
not all required fields have been entered I would like Access not to try to
move to a previous or new record.
thx, in advance
George Papadopoulos