Combo Boxes in a Form

[Glencannon4424 via AccessMonster.com]

I have a couple combo boxes and a couple text boxes in my form. The combo
boxes are pulling from separate tables and queries. Ultimately, I would like
the user to select their choices from the combo boxes, type some information
into the text boxes and then click a command button to write the data to a
table.

At this point, it is only writing the text box information in the table. How
do I get the form to write the selections from the combo boxes into the table?


Thanks for your help!

 

[Wayne Morgan]

Set the Control Source property of the combo boxes to the field in the
form's Record Source that you want the combo box's results saved into. The
combo boxes will then save the value from their Bound Column into the field
you have selected when the record is saved, just as the textboxes do. If you
look at the textboxes, you will probably see a field name in their Control
Source property.

Be aware that if you have more than one column in the combo box, the Bound
Column may not be (and in fact, probably isn't) the visible column.