Hello,

Im in the middle of making a program and ran into a problem.

What I have is a table named "Address" , it contains the fields ,

Name
Address
City,State
P.O Number

On my main screen named "Msa_main" , where the "Address" table is located I have 'Name' as a combo box , this way they can type in a name or scroll through the list for a name..

Now what I want it to do is :

when you enter a name and hit tab ( or whatever key ) if it exists in
"Address"database in the "name" field , then fill in the 3 other fields .

Another problem Im having is when there's a name that dosent exist and you type in a new name , it's not storing it in the name field , or in the database , it's storing the new 'Address',CityState,P.o Number' but not the 'Name' field.

Could someone please help me out with this ..

Thank YOu.

Charles Simmons