Synchronized combo boxes

[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.

 

[Guest]

Berkin,

This question has appeared many times. It is easier to look at the previous
answers rather than wait for a reply.

http://groups.google.co.uk/groups?a...81&as_maxd=30&as_maxm=8&as_maxy=2006&safe=off

Alastair MacFarlane

 

[Guest]

Change the sub categories combo to a multi select list box. It will allow
you to select multiple sub categories; however, be aware there are some
differences using a multi select list box. You really can't bind it to a
control because refering to it's value will return Null. You have to address
each item in the list.

If you need a different record for each subcategory in your table, you may
need to change to a form/subform construct.

 

[twas]

It sounds like you need a many-to-many setup between the Committees and the
Senators. In addition to changing to a form/subform construct, you might
need to change the structure of your database. It sounds like the current
structure might only allow the recording of a senator in one committee.
There are messages and tutorials available on many-to-many structures.
- twas