I have been working on a database that uses addresses with the city, state, county and zip code. I'm trying to set it up so that when you enter the zipcode it automatically fills in the county, state and city. I have made a table that has all of the zip codes with city, state and county. I can link it to the form no problem, but I can't get it to automatically fill in the form after I enter the zip code. I don't understand what kind of syntax I should be using or how to name and define the macros and code. Can someone give me an example of a simple form that does that. I set it up so that you have to enter a valid zip code, but I don't know how to use that table to fill in the form with the appropriate information.
I would apprecaite any suggestions.

You make a combo box for the zipcode, if you do it with the wizard, it will ask for options then select option 3 'Find a record.....' then it'll fill the form for you
Col