Unbound ComboBox Help

[smbarney]

This is a stupid problem, but I just can't seem to figure it out (some days I am smarter than others).

I have a form with three unbound comboboxs that are synchornized so that what you select in the first combobox changes your options in the 2nd and 3rd boxs. My problem is that I want to record the selections made in the unbound comboboxes in the table attached to the form, but cannot seem to make it work. Help!!

I am using Access 2000.

Thanks.

 

[MStef]

Link the comboBoxes with the fields in the table.

 

[bonekrusher]

If your form is bound to a table, then in your combo box bind your control source to the field.

right click on the combo box>properties>control source>select the field from drop down menu.

bones

 

[smbarney]

Thanks...works fine...should have thought of it in the first place.