Solved Combo Box I need 2 values instead of 1 (1 Viewer)

[mloucel]

Hello ALL, Newbie Here.

I created the combo box using the wizard from a small database called ZipCodesCal that contains ZCode and City

The EU (end user) can pick a ZIP, and save that value to my database using the combo box.

The combo is displaying the ZIP and the CITY as well but the combo box wizard just allow me to save the zip and not the city.

I would like to be able to save both things as well of course I need to display them in the correspondent fields in the form
so if I choose 90005 it will display 90005 in the zip and display and save the city in the city field.

I'm sure there's gotta be a way to do this but I don't know how, any help will be appreciated.

Maurice.

 

[The_Doc_Man]

With VBA, you can save both the ZIP and the CITY if they are fields in the combo.

Automatically fill in Access text boxes based on a combo box selection | TechRepublic

You can greatly enhance a form by having Access supply information based on the user's selection. Here's an example that will fill in an employee's first name and phone number when the user chooses that person's last name from a list.

www.techrepublic.com

This shows you how.

 

[mloucel]

With VBA, you can save both the ZIP and the CITY if they are fields in the combo.

Automatically fill in Access text boxes based on a combo box selection | TechRepublic

You can greatly enhance a form by having Access supply information based on the user's selection. Here's an example that will fill in an employee's first name and phone number when the user chooses that person's last name from a list.

www.techrepublic.com

This shows you how.

Cool easy and simple, Thanks Doc ..