Thread: MS Access Zip Codes

The database I am including is a very useful database. It contains the zip codes for the 50 states, DC, and Puerto Rico.

For fun, I added two forms, one of which has a subform. Basically, the forms allow you to search either by zip, where you enter the zip and click on search, or by city/state search, where you choose the state in a combo box, and then the city in a combo box. Then every zip for that city and state is listed in a subform.

The first form is called "ZipSearch", and the second form is called "CityState"

Now, if you ever need it, you will have all of the cities and zips at your disposal.

The table (only table) consists of three fields, Zip, City, and StateCode.

Enjoy, and may this bring ease to future database developments.

Without further adieu, here is the database:

how can you use the zip as the primary key. i know for a fact that there are 4 cities in PA all with the same zip.

primary key has been removed allowing for adding two cities with same zip.

Will see if I can find a better list to import.