[AccessD] Help!

Hi Doris,

First, welcome to the list.

Do you realise you posted the same question twice with different subjects?
The one under "Add new data to existing table" had replies earlier today.

-- Andy Lacey
http://www.minstersystems.co.uk 

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> DorisH3 at aol.com
> Sent: 07 December 2004 14:16
> 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
> 
>