Multiple Same Fields in Access Forms

[tlynn1]

I hope this isn't too wordy...

I have a form that I am trying to create. It only has three columns on it, but I need to be able to recognize 2 of the 3 fields until I change it. Below is an example of what I want to be able to do on the form....

State: Tennessee
City: Memphis
Zip Code: 38111


38112
38114
38115
and so on with adding the zip codes, until I get to a new City, and eventually a new State. I don't want to have to continue to type Tennessee and Memphis, but I can't set those fields (like a date field), because they will have to change at some point.

Please Help!!

[pbaldy]

Does this help?

http://www.mvps.org/access/forms/frm0012.htm