HELP! Using a list box to go to a specific record

S

SGT Pead

I have a form that is pretty much an address book. I would like to have a
list box that is auto populated with the first and last names of the people
in my database. When a person is selected in the list box I would like the
form to be populated with that information.

I have ran out of ideas that would make this happen. I just don't like
having to go through my entire database or go to "table view" to edit a
specific record.

Is there a way to do this. Thanks.

SGT Pead
United States Army
 
N

NevilleT

Hi
I would use a combo box and create a query as the row source. The query
would have person number, first name, last name and a calculated field that
combined the two names. You can then select which rows to display in the
combo and use that to display the record.

The combo wizard will guide you through with the exception of creating the
calculated field in the query That will be something like:
FullName: LastName & ", " & FirstName

Assuming the last name is Smith and the first Bill, it will display as
"Smith, Bill"
Hope that helps
 
Top