Auto-populate

[Guest]

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?

 

[Douglas J Steele]

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

 

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