[AccessD] Help!

I have a older sample that does this. I'll send it to you off the list.

David

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Andy Lacey
Sent: Tuesday, December 07, 2004 10:25 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [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
> 
> 

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