Using Lookup or combo box to pull up entire record

[Don]

I want to be able to search for a name and, once found,
all of the fields (address, city, state and zip) also
appear on the form - based on the name.

I'm a newbe... is the above possible??

Don

 

[kevin watkins]

Don,
Yes that is possible, If you go to the northwind sample
database. It has this used on the form called "Orders"
if you select the top right box and change the selection
it pulls the records for this selectiion. Then the
subform is used to enter details for that customer. This
may help get you started. There are other ways to do this
as well. You can use a form to select the name, then have
a button that goes to another form sorted with all that
information. Good Luck
Kevin

 

[Van T. Dinh]

If you meant using the selection in the ComboBox to change the CurrentRecord
of the Form to the one selected in the ComboBox, then use the ComboBox
Wizard to create it (including VBA code) for you. Select the option "Find a
record on my form based on the value I selected in my combo box".

If you meant like selecting a Customer in data entry of an order, the use
the example in the sample database "NorthWind".