1st listbox populates 2nd listbox, allows multi selections

[Repent34]

I am trying to setup a form that has basically two boxes. the first
is a box that lists all available categories. The second box is empty
to start. when the user selects a category in the first box, only the
options applicable to that category are listed in the second box.
Since more than one option can be correct the user needs to be able to
select multiple items on the right.

The user then needs to be able to select another category on the left
and select multiple options, again, on the right.

There are 12 categories listed on the left with applicable options on
the right. the user will have to go through the category list on the
left, one by one, and select multiple options on the right as they do
so. After the user has selected the last category and options set,
there should be a button labeled "Done" nearby that the user clicks on
to record all the categories/options selected and to close the form.

this form will be started from a macro button on another form.

any help would be greatly appreciated.

 

[Jeff Boyce]

You've described "how", as in how you've decided to handle an issue/problem.

You haven't described "what", as in what business issue/problem are you
trying to solve.

Are you saying you can only accomplish what you need to by doing it this
way, or are you asking for folks here to offer ideas on how to solve the
problem?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Piet Linden]

I am trying to setup a form that has basically two boxes.  the first
is a box that lists all available categories.  The second box is empty
to start.  when the user selects a category in the first box, only the
options applicable to that category are listed in the second box.
Since more than one option can be correct the user needs to be able to
select multiple items on the right.

The user then needs to be able to select another category on the left
and select multiple options, again, on the right.

There are 12 categories listed on the left with applicable options on
the right.  the user will have to go through the category list on the
left, one by one, and select multiple options on the right as they do
so.  After the user has selected the last category and options set,
there should be a button labeled "Done" nearby that the user clicks on
to record all the categories/options selected and to close the form.

this form will be started from a macro button on another form.

any help would be greatly appreciated.

did you read the articles about filtering multi-select listboxes on
Access Web
www.mvps.org/access
?

Start there. Play with the examples, experiment, learn.