[AccessD] Help!

I would probably tell the user in a message box that the zip code is not in
the database and ask if they would like to add it.  
If so, open a new form that allows the user to add a city and state for the
zip code entered.  Then after saving the new data, set the fields on the
original form to the values entered for that zip code.

Bobby

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of DorisH3 at aol.com
Sent: Tuesday, December 07, 2004 9:16 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Help!


I want to apologize ahead of time for my ignorance of Access but I am new to

this and would appreciate any help that would come my way.

I have a Customer entry form whereby I am entering customer first name, 
customer last name, address, zip code, City, State and remarks.  I also have
a 
ZipCode table where I have  Zip Code, City, State fields. When I am entering
data 
into the Customer Entry Form the Zip Code field goes out and looks up the
City 
and State and returns the value from the table on exit from the Zip Code 
field.  My question is this:  when a value is not found in the Zip code
table that 
matches the entered zip code, how do I from the Customer entry form add the 
Zip code, City and State to the Zip Code table?

Again, I appreciate any help you can extend me.

Doris
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com