Listbox with multiple check boxes

[Mark Andrews]

In Access 2003 what is the best way to show a number of options where the
user is allowed to have multiple selections.

I would like to do a listbox with checkboxes in it, such as:
http://office.microsoft.com/en-us/access/HA100311171033.aspx#3

what's the best alternative in Access 2003?

- listbox with multi-select (force users to understand that the highlighted
items are selected)
- some kind of subform
- some kind of popup form (using continuous forms)
- hide/show checkboxes with code (using a popup form with room enough for 40
choices if needed)
- something else???

I expect to have between 5 and 20 choices usually but it's user defined so
number could vary.

Thanks in advance,
Mark

 

[Dale Fye]

Mark,

When I want that functionality, I generally use a continuous subform. I've
found that even after all these years of using Office, most people cannot get
the hang of selected extension listboxes, but they do understand checkboxes.

If you have multiple users, you will want to create a local table where you
can dump the contents of your list. The only difference between this table
and the one on your network will be a Yes/No field that you use for your
checkbox. I design the subform to look as much like a listbox as possible
(this includes code in each of the visible textbox GotFocus events that
resets the focus to the checkbox), and let the users us it.

When I load the form, I load this local table, and then requery the subform.
When I close the form, I delete the records from the local table.

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.

 

[NTC]

one approach would be to have all 20 check boxes on the form but only make
visible or active based on your logic of user choice implemented with VB
after each Update Event

another approach would be a cascade of list boxes where the correct
available list is sourced from a query that is developed dynamically by the
prior choice of the user.

a third approach could be a set of individual forms; all as pop ups...and
depending on the choice made the appropriate form appears next....

in either case it begins with the user making some choice, and then
depending on that choice - the next offering is displayed.

I myself would not put the check boxes in the list box...but it is a matter
of design preference

 

[Mark Andrews]

Thank you for your ideas.

Mark,

When I want that functionality, I generally use a continuous subform.
I've
found that even after all these years of using Office, most people cannot
get
the hang of selected extension listboxes, but they do understand
checkboxes.

If you have multiple users, you will want to create a local table where
you
can dump the contents of your list. The only difference between this
table
and the one on your network will be a Yes/No field that you use for your
checkbox. I design the subform to look as much like a listbox as possible
(this includes code in each of the visible textbox GotFocus events that
resets the focus to the checkbox), and let the users us it.

When I load the form, I load this local table, and then requery the
subform.
When I close the form, I delete the records from the local table.

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.

 

[Mark Andrews]

Thank you for your ideas.

one approach would be to have all 20 check boxes on the form but only make
visible or active based on your logic of user choice implemented with VB
after each Update Event

another approach would be a cascade of list boxes where the correct
available list is sourced from a query that is developed dynamically by
the
prior choice of the user.

a third approach could be a set of individual forms; all as pop ups...and
depending on the choice made the appropriate form appears next....

in either case it begins with the user making some choice, and then
depending on that choice - the next offering is displayed.

I myself would not put the check boxes in the list box...but it is a
matter
of design preference