Checked listbox with labels

[Patrick B]

I'm trying to create a form that allows the user to check off multiple
options, like a checked listbox. Except the list should be divided into
categories.

Example:

Category1
[ ] Option 1
[ ] Option 2
[ ] Option 3
Category 2
[ ] Option 4
[ ] Option 5
Category 3
[ ] Option 6
[ ] Option 7

How can I create this effect in Access? I could do something like this
with a report (by adding a grouping level for the "Category" field), but
I can't figure out how to do it with a form. If you could put a
continuous form as a subform within another continuous form then my
problems would be solved, but you can't.

Does anyone know a way?

Thanks!

-Patrick

 

[Michel Walsh]

Hi,


Not using option button (they have to be instanced, INDIVIDUALLY,
graphically), but with a list control. The "category" number defines the
"filter" for the records to be displayed in the list.


Me.ListnameControl.RowSource = "SELECT ... FROM ... WHERE
categoryNumber=FORMS!FormName!ControlNameForCategoryNumber"


If your list control allows only one selection, you are "like" an option
group, but items can be easily added/removed: just add or delete a row in
the table implied in the row source.



Hoping it may help,
Vanderghast, Access MVP