error when field last name is 'empty'

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

Guest

Hallo,

I am using a code from the book - Building Microsoft Access applications -
to search for duplicate names when adding a new contact. Last week it
suddenly returned a specific error. It took me some time to find out that the
code behaved that way in my database because the field last name was empty in
one of the records. I thought I might use a code to return a message when
someone leave the field empty by accident. But this does not solve the
problem, is there a better solution? Thanks in advance for any help!

Srwe
 
Hi David,

Set that field's Required property to Yes in the table Design View and users
will not be able to save a record without entering data in that field.
 
Thank you for your helpful and quick reply!

SusanV said:
Hi David,

Set that field's Required property to Yes in the table Design View and users
will not be able to save a record without entering data in that field.
Click to expand...
 
Back
Top