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

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

Guest

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?
 
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
 
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
 
Back
Top