How do I save the selection of a synchronized combo box?

[Guest]

I have two combo boxes on a form that are already synchronized; the first
combobox cboCategory allows you to pick between types of clients, i.e. US
Govt, NGO's, etc. The second combobox cboSubCategory uses a table/query to
bring up the list of subcategories based on the selection in cboCategory. My
problem is this: when the user makes their selection in cboSubCategory, I
want that selection to be saved to the current record it is displaying in the
form, and on a table. And when I move to a new record, I want that selection
to be reset. Currently, the selection in both comboboxes stays at whatever
selection is chosen, regardless of the current record, and it is not stored
in the source table, though I have not set up a field for that yet because I
don't know how.

 

[Jeff L]

Your fields are not bound to a field in your form's Record Source. If
you want to do that, look at the properties of your field, click the
data tab, and put the name of the field that holds the data in the
Control Source box.