How do I find a record in Access if I only know 1 piece of info?

F

fiona

Using Access 2003, I want instant access to individual client records when I
only have one piece of information. How can I achieve this using access?
 
M

mscertified

The one piece of information needs to be a unique key which will lead you to
an individual record. Any other field will potentially match on multiple
records.
Its like looking in a list of people for the ssn versus for their first name.

-Dorian
 
F

fiona

Ok, so how do I enter this piece of information, (is there some kind of
search function?)
 
L

Larry Linson

A simple approach is to use the Combo Box Wizard, which has an option to
allow you to use it to select the record matching the selected key. It also
defaults to AutoExpand, so if you start typing the value, it will
automatically scroll to the closest match in the dropdown list as you type.

Larry Linson
Microsoft Access MVP
 
Top