I know there have been old threads on this issue. I have done a search and read them. That is how I got this far. I was able to search the Web, find a Govt site with a list of every zipcode in the country. It was a text file so I converted it in excel and then imported into an Access table. I now have a 4 field table with every zip in the country-city,state,and Zipplus a auto number field as my primary key. My db is name and address intensive in multiple tables. I want to use a combobox to lookup and display city,state and zip on my forms from this table instead of storing the information. However, If I do this and then want to generate a mailing list how can I do this if the city,state,zip info has only been displayed from a combobox and not stored in the underlying table? Since I am using an autonumber as the primary key for the city,state,zip table can I include a field for that pk in an invisible field and just store that? If anyone wants the table of zipcodes let me know. I'll be happy to upload it.
