multiple categories possible?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am building a database in which each record is assigned a category from a given list. It would be great if I could assign some records to multiple categories. Is it possible to create a drop down list of available categories in which users can select multiple categories? I would appreciate any / all the help I can get. Thanks.
 
The usual way is to create a table to "store this list".

You then create a sub-form, and put in the above table the category id (you
use a combo to do this).

Thus, with a continues sub-form, you can place as many categories as you
want.
 
The easy way is to do as Albert suggests.

The harder way is to use a Multi-Select ListBox (not drop-down list, i.e.
ComboBox), but will need to write a fair bit of VBA code to handle the
saving of the Categories selected since you cannot use "bound" Multi-Select
ListBox as the Value is *always* Null.

--
Van T. Dinh
MVP (Access)



Jen said:
I am building a database in which each record is assigned a category from
Click to expand...
a given list. It would be great if I could assign some records to multiple
categories. Is it possible to create a drop down list of available
categories in which users can select multiple categories? I would
appreciate any / all the help I can get. Thanks.
 
Back
Top