Combo box

  • Thread starter Thread starter Tony
  • Start date Start date
T

Tony

I really appreciate any help anyone can offer. I'm trying
to automatically populate multiple fields from a combo
box. My example is to populate City, State, and Zip fields
from a combo box listing Zip codes.
 
Tony

I would use the combo box to get the zip code the use the use that value in a a series of 'dlookup' functions to get the values of the city state zip etc. If speed is an issue you may even load all this data into an array when the app loads

example 1

combo box = 'cboZipCodes
zip code data table = 'tblZipCodes

me!txtCity = dlookup("city","tblZipCodes","zip_code = '" & me!cboZipCodes & "'"

Hope this helps - Ke
 
Back
Top