Multivalue selection control has no check boxes.

I think what I want is a listbox control from which I can select multiple items by left-mouse click. Also want to de-select by reclicking a previously selected item. When I try to create a field a table with the Lookup Field Wizard, I do not see the option to "allow multiple selection" at the end of the Wizard.

Okay. Cannot, however, a table in Access2007 maintain a lookup-type field which acts like a typical data field, but is capable of assembling compound data items, delimited by commas by default, which it collects from a user interaction with a series of data elements stored in internally maintained subordinate lookup tables and available to users through a listbox control that presents check boxes before each of the available data items and alows a choice of more than one item?

Here's what I mean:

http://office.microsoft.com/en-us/access-help/use-a-list-that-stores-multiple-values-HA010031117.aspx

Most developers do not use these new multivalued fields.
They have issues.
See here:
http://allenbrowne.com/Access2007.html#Mixed
http://www.theregister.co.uk/2006/07/18/multivalued_datatypes_access/
http://www.pcreview.co.uk/forums/multivalued-field-join-clause-problems-access-2007-a-t3869977.html
http://www.dbforums.com/database-concepts-design/649369-multivalued-field-seach-problems-cont.html
http://splunk-base.splunk.com/answers/11703/problems-comparing-multivalue-fields
http://www.accessmonster.com/Uwe/Forum.aspx/access-queries/47010/subreport-problems-with-multivalued-fields
...etc

Since you did not post any info on your table, ...or the fields, ...or the properties,  or posted a sample for us to examine, ...
...it is difficult to say what went wrong.

Instead of referencing a link describing how to *use* these fields, why not view a link that shows how to *create* them?
http://office.microsoft.com/en-us/access-help/guide-to-multivalued-fields-HA001233722.aspx#BM4
When I tried this it worked fine.

;-)

JeffCoachman

Hi, Jeff. Actually, I was only considering upgrading some forms that I use a lot and saw the posibility of exploiting this technique. I had not put down any code as yet. I'm currently using a dozen discrete Y/N fields of the bound table to collect the user's selections and from this I build a simple string for the particular report by concatenation. It works fine. Just thought I'd try something snazy. Appreciate the help!
--Greg

...so make sure you note step 8 in the link I posted:

   8. Under Do you want to store multiple values for this lookup?, select the Allow Multiple Values check box.

 Note   This check box must be selected to enable storing multiple values.

JeffCoachman

Thanks to all!

Yes, they are snazzy, but again, ...they have issues.

If you must use them, use them in your forms only (not in the table) and only for *simple* designs.

JeffCoachman