Prevent user quit in the middle of input

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

Guest

Hi, Everyone,

I have a subform for the user to enter the details. However, I found that
some user may enter the data without press Tab or Enter and select [Next]
Record. (Esp why the user come back doing editing). As a result, the data
field remain blank or zero. Could you advise me how to avoid such behaviour?
Thank you.

BL
 
BL said:
Hi, Everyone,

I have a subform for the user to enter the details. However, I found
that some user may enter the data without press Tab or Enter and
select [Next] Record. (Esp why the user come back doing editing).
As a result, the data field remain blank or zero. Could you advise
me how to avoid such behaviour? Thank you.
Click to expand...

If certain fields in the record are required, define them that way in
the table's Design View, but setting the Required property for these
fields to Yes, and clearing the Default Value property so that no value
is automatically entered for the field if no entry is made. If you do
that, the database will not allow a record to be stored that has nothing
entered in the required fields.

If you don't like the default message that Access displays when the user
attempts to save a record with required fields empty, you can use code
in the form's BeforeUpdate event to check the required fields, display a
friendlier message if any of the required fields is Null, and cancel the
event.
 
Back
Top