List Box or Faux-option group?

[Karen.Reedy]

I have a database tracking a variety of different things in our stores
(paint, fixtures, graphics, etc). Our Visual Design people want to add their
items, which the store could contain several of within the same category.
What is the best way to track multiple selections of data and be able to
report back on it? Using the example below, I may want to find all the
stores that had black wall-mounted signs for a query/report.

Ex: Wayfinding signs - select all that apply: black, gray, wall-mounted,
integrated or custom.

Help? Their preference is for check boxes, but I've already discovered that
option groups only allow ONE selection and I really don't want the back end
mess of a yes/no field for each possible option in the group. Is that the
only way? TIA!

 

[mscertified]

Just don't include the checkboxes in an option group! A listbox will be
easier to program than multiple checkboxes. Also a listbox can be loaded from
a table even if the table values change. With a set of checkboxes you will
have to change the screen if any new options are added.

Dorian

 

[Karen.Reedy]

So that opens another can of worms. I've seen references to a multi-select
field in the table setup for the form, but I can't seem to locate that option
to turn it on. (Using ACC 2000) Is that an option that pre-dates this
pathetic antiquated version of the software they're forcing me to run? (grin)

 

[John W. Vinson]

So that opens another can of worms. I've seen references to a multi-select
field in the table setup for the form, but I can't seem to locate that option
to turn it on. (Using ACC 2000) Is that an option that pre-dates this
pathetic antiquated version of the software they're forcing me to run? (grin)

Nope, I think it goes back two or three versions before that. <g>

Open the Form in design view. Add or select the listbox. View its Properties.
On the "Other" tab select "Extended" on the multiselect property.

You'll need some VBA code to *do* anything with the multiple selections,
though!

John W. Vinson [MVP]

 

[Karen.Reedy]

That's where the item selected property comes in, right? I'll be back if I
can't figure that part out. Thanks!