DorisH3 at aol.com
DorisH3 at aol.com
Tue Dec 7 08:15:44 CST 2004
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