Enter a last name in a form and the attached infomation fills in

D

Dottie S

Using Access database, how do i type in the last name of a customer and his
information fills in the form
 
F

fredg

Using Access database, how do i type in the last name of a customer and his
information fills in the form
Click to expand...

You could add an unbound combo box to the Form Header. If you use the
Combo Wizard, select the 3rd option on the first page of questions,
something like "Find a record ...".

However, using a Last Name by itself to find a record is risky at
best, as it's quite common for more than one person to have the same
last name. How would you differentiate between Joe Smith and John
Smith?

In the Combo Box, use a Prime Key field, LastName field, FirstName
field and perhaps an Address field in the combo box. You would hide
the Prime Key field, and display the others. You can then select the
correct individual, and Access can locate the correct record by using
the Prime Key field.
 
Top