zipcode lookup table-Access 2007

[Guest]

I have a table (Zip) that lists cities in the first column, and corresponding
zipcodes in the second.

On my form, after I type in the city name in a textbox (bound to my primary
table), I would like to automatically have access find the corresponding
zipcode in the table, enter it in another textbox on my form with that
zipcode then being stored in my primary table. I am also using the Zip
table to populate a drop down combo box that displays the names of the cities.

Any help would be appreciated.
Thanks

 

[Guest]

You are aware that many cities have more than one zipcode?
Check out Access help for combo boxes. It tells you there how to make one
combo box dependent on another.

Dorian

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "CascadingComboBoxes.mdb" which illustrates how to do
something like this.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[John W. Vinson]

On my form, after I type in the city name in a textbox (bound to my primary
table), I would like to automatically have access find the corresponding
zipcode in the table, enter it in another textbox on my form with that
zipcode then being stored in my primary table.

Many, many cities have multiple zipcodes.
Many zipcodes refer to more than one city.

Don't jump the gun on your design...!

John W. Vinson [MVP]

 

[UpRider]

Download http://www.dbtc.org/zipmdb/ziplookup.zip Udated and simplified
recently!!

It shows how to type in a zipcode and if the code applies to more than one
city, a popup form with a listbox allows you to choose the proper city for
your main form.

UpRider