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 drop box.

Now what I want it to do is :

when you enter a name and hit tab ( or whatever key ) if it exists in
"Address" fill in the 3 other fields . It does this part great.

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

I would be very happy if someone could clue me in on how to get this working .

Thanks You

Charles Simmons