error when field last name is 'empty'

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
 
S

SusanV

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.
 
G

Guest

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Parse First Name from Name Field 6
Code to look up a number if field is null 2
Updateing a record with a Null value field, fails? 5
empty field 2
Trying to run excel vba code when cell value changes from empty to entered value. 1
VBA - retrieve data on last create named range from previous inserted named range 0
check if a field is null or empty 2

Top