auto lookup form field

[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?

 

[John Vinson]

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?

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?

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]