auto lookup form field

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

Guest

Can someone tell me how to set up a field in Access that will do the type
ahead feature so as I'm entering in information in starts to fill in likely
selections?

Also, if I'm entering data into a form how do I set it up to enter, for
instance, someone's name in a different field if I type an SSN that's already
associated with it in the database?
 
Can someone tell me how to set up a field in Access that will do the type
ahead feature so as I'm entering in information in starts to fill in likely
selections?
Click to expand...

Use a Combo Box to enter the field.
Also, if I'm entering data into a form how do I set it up to enter, for
instance, someone's name in a different field if I type an SSN that's already
associated with it in the database?
Click to expand...

Well, you would NOT want to store a name and a SSN redundantly in a
second table. What are the tables involved? If you have a SSN field
(as a primary key? not wise, they're not unique, can be forged, and
not everyone has one), do you want to *store* that person's name
redundantly, or just display it?

John W. Vinson[MVP]
 
Back
Top