Can't copy data from combo box to table

[gophertee]

Ok Access has kept me up at night trying to figure this out. I created a combo box in a form. This form has data [RowSourceType=ValueList] and [RowSource=widget1;widget2;widget3]. Running the form, the combo box displays the three categories of widgets as it should. However I am not able to send what was selected in the combo box to a table or query.
Basically in a nutshell, what I am selecting in my combo box I want written to a table.
Keep in mind this data IS being pulled from the row source..We can not enter data into the combo box. You must select what is there....

I tried expressions stating combo.rowsource = tblWidget.widget. However for some reason it never gets saved to the table. UGGGGGGGH.

Heck, all I want is data in my combo/list box to be written and saved to a table. Is that so hard?

 

[Nancy2]

Ensure you combo box control is bound to the field you wish to fill (control source)

 

[gophertee]

How do I make it bound? The combobox does say Unbound..
Do I just type in the table name or use the expression. And if I use the expression, how do I copy what I selected in my combobox to the table?

Thanks in advance for helping....
terry

 

[Nancy2]

1) Ensure your form is bound to the table or query (Form Properties, Record Source) -- if you look at the field list (button on the toolbar) and see the fields you are all set.

2) Once you know the field is there, type or use the pulldown in the combo box control source property and select the field name - this will make the combo box bound.

 

[gophertee]

UGGGGGGGGGGH I am ready to give up. In my RowSourceType I have [Value List]. In my row source I have [widgetA, widgetB,widgetC]. Keep in mind my table (tblWidgets) is blank and has nothing. What I select from my row source should go into the table. Now when I follow your instructions and bound the ControlSource to tblWidgets I still see my row source but can not select anything.Everything drops down from the combo box but will not let me select.
I will understand if you give up on me. I only been messing with this the past 12hrs....

 

[Nancy2]

1) is the RECORD source of the FORM tblWidgets? Double click in the box/button which upper left corner of the form and you will see FORM properties
2) Value list is OK for the ROW source of the combo box. If RECORD source of FORM is tblWidgets, the CONTROL source of the combo box should be the field name you are filling.