Multi Select Check Boxes?

[CDavis10]

I am working on a form and one of the things the boss wants on this form is a place to select all the components included in a bid. There is a table with about 20 components and a code# associated with each one.. so I can make a list box that lists all of those components, and I can set the properties to multiple select, however, there is an option on the form called "Attic Storage included" and that will be a check box. Rather than having ONE attic storage check-box for the whole form, He wants to be able to select that option for each component.

I personally do not like the list box because it just highlights the selected items. I would like to make it where the user can check off which components are included in the bid, and then for each of those, check off weather attic storage is included.

[ssanfu]

You cannot have a check box that is "check-able" in a list box. (as you probably found out)

Have you tried/thought about using a sub form?

[offie]

Can you include a picture or example of what you want or something? I am doing something very similar, a form where I enter search criteria as well as what fields I would like to show in the resulting query, is that kind of what you are looking for?

The way I am doing it you could have a combo box for weather attic storage (Y/N) to select what you want.

If this is along the lines of what you want I can show you my code and sql