Auto-populate

D

Dana

My access form has the fields Last name and First name. When I enter
someone's last name how do I get the first name field to auto-populate with
that persons first name?
 
D

Douglas J Steele

What do you expect to have happen when you have multiple people with the
same last name?
 
M

ManningFan

ZIING! ALthough you can alway sinclude the middle initial with the
First Name field

To answer the question, try doing a DLookup on the table, searching for
the value of the first combo box. You'ld probably want that on the
"After Update" event.
 
Top