Need Help Getting Form to Store Value From cbo!! 2

[zachsiue]

Hi,

I have created a 2 combo box form. The first combo box determines what is in the second combo box. I did this by having the second combo box run a query using the selection from the first combo box. It is working fine, except I can't get the value from the second combo box to store into the table that form is built from. Is it possible to get the value stored into the table? If so, how? I'm am a new user to access, so please include as much detail as possible.

Thank You in Advance,

Zach

 

[kewo99]

Hi Zach,

You need to bind the control to the appropriate field.
In Design View of the form, select the combobox,right click and select Properties. Set the Control Source property to the field you want to store the combobox value.

Ken

 

[zachsiue]

Worked perfect!!

Thanks,
Zach