zipcode lookup table-Access 2007

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
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.
Click to expand...

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]
 
Back
Top