Binding a Combo Box Search Result

[cvansickle]

OK.. I have admitted in threads in the past, that I am a rookie when it comes to access. But through all of your help, I have learned a great deal.



However, I have gotten myself stuck again...

I have a table with all the Zip codes and the City and States they belong to.

In my form, I have an unbound combo box search that finds the zip code and then in my Text Box, I have a formula in the Control Source that says =[Combo632].[column](2) It will show the city or state based on which column it is in.

My issue... I dont know how to bind those results. So that when I save the record, it saves the correct city and state in the form.

I hope this make sense... and I thank you in advance for your help..

Chad

[jo15765]

Go to your form, and bring up the design view. Right click on the combo box and say properties, and under the Data Tab the top option "control source" use the drop down arrow to choose what field on your table you want this combo box to be bound to.

[cvansickle]

The "control source" currently has my formula in it. "=[Combo632].[column](2)" So I cant change it can I??