I want to write value to the table based on combo box

M

monia13

I want users to choose a value from the value box in the form and I want that
value to be written to the table. How do I accomplish this? Right now the
value can be picked from the combo box but the table field remains blank.
 
R

Rick B

What is the control source of the combo box? Is your box bound to a field
in your table? If not, the selections would have no place to save.

Did you use the wizard to build it? It will do all the work for you.
 
A

Al Camp

Monia,
You need to "bind" the Combobox to a field in your table. For example,
if the combo allows the user to select a CarModel, then the ControlSource
for the cpmbo would be the CarModel field from your table.
 
Top