Subforms?

[teiben]

Been away from access for a while; I have a form with a control (listbox, checkbox, combo box) in which I want my user to select multiple items; Initially i have all possibilities coming from a table w/checkbox, but I've it wasn't normalized that way, so i created a tbl call LOB.
Now I'm unsure of what type of control to use, listboxs don't support multiple selections nor does comboboxes, so that leaves subform?
any other idea?

 

[pbaldy]

Not sure why you think listboxes don't support multiple selections, as they are the most common tool used to allow multiple selections. In the listbox properties on the Other tab should be a Multi Select property.

 

[teiben]

Thanks Paul but I started off trying a listboxes w/multi select set at "extended" and it wouldn't store multiple values, only one value.
HELP

 

[pbaldy]

Let me start off by saying I have no experience with the new multi-value fields. I don't think they represent good design. If you're using that, I will have to plead ignorance.

Failing that, a regular multi-select listbox won't store anything directly. If you're using one to add records I use a technique like this:

http://www.baldyweb.com/MultiselectAppend.htm

If you want to store multiple values in a field, which I wouldn't:

http://support.microsoft.com/default.aspx?scid=kb;en-us;210203

 

[teiben]

thats the Problem, I don't want to store multiple values in a field & multi-select listbox won't store anything directly.....so what are my alternatives?
thinking subform w/lots of checkboxes (which will allow multiple selections) and values (from an ID in a table) are bound to another table