Auto-populate

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

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?
 
What do you expect to have happen when you have multiple people with the
same last name?
 
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.
 
Back
Top