multiple categories possible?

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

 

[Albert D. Kallal]

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.

 

[Van T. Dinh]

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)

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.