G
Guest
I have two synchronized combo boxes, with the second set to table/query based
on the selection in the first box. cboCategories is bound to my Categories
field, and cboSubcategories, is bound to my subcategories field. Everything
works great. The only problem is that I've realized for certain entries I
need to make more than one selection in the cboSubcategories and have both
selections record in either the one subcategory field, or I can add an
additional field. For example, cboSubcategories has choices like Senate
Approp. Committee, Senate Agriculture Committee, etc. Some Senators will
belong to both of these committees and I need both recorded.
I know one alternative is to use check boxes instead of comboboxes but this
is a very messy solution. Please help. Thank you.
on the selection in the first box. cboCategories is bound to my Categories
field, and cboSubcategories, is bound to my subcategories field. Everything
works great. The only problem is that I've realized for certain entries I
need to make more than one selection in the cboSubcategories and have both
selections record in either the one subcategory field, or I can add an
additional field. For example, cboSubcategories has choices like Senate
Approp. Committee, Senate Agriculture Committee, etc. Some Senators will
belong to both of these committees and I need both recorded.
I know one alternative is to use check boxes instead of comboboxes but this
is a very messy solution. Please help. Thank you.