drop down list that populates more than one field

[Cherri]

I have a master table and a table titled location. The location table has 3 columns: City, State and Zip. I want to be able to select the zip code from the drop down list and have the city and state automatically populate in their perspective boxes. Can anyone tell me how to do this? Thank you!

[June7]

Make comobox a multi-column with City, State, and Zip. Then a textbox ControlSource can have expression that references the combobox columns. Column index begins with 0 so if State is in the second column:

=[comboboxname].Column(1)

This will not save the data to table. That requires code. However, there is no reason to save City and State. These can be retrieved by joining tables in queries.