multivalue check boxes

[rlbroerman]

I am trying to add a multivalue list box to a form. I want this list box to save multiple values.
I found a way to do this in the Access help under “Add or change a lookup column that lets you store multiple values” I want this to look like sample shown in thr Help.
The part that doesn’t work like I thought it should is found in
Add or change a lookup column that lets you store multiple values
Then
Using the Lookup Wizard to create multivalued lookup columns
Then
7. Under Do you want to store multiple values for this lookup?, select the Allow Multiple Values check box.
The above doesn’t appear in the Wizard.
Allow Multiple Values doesn't appear in field properties in the table.
The beginning of the help says this is new in Access 2007.
Do I need to turn something on to make this work?
Or does my version Access 2007 not have this?
Or should I do something completely different?
Thanks for the help.
Rick B
rlbroerman@wowway.com

 

[boblarson]

1. Don't use lookups at table level:
http://www.mvps.org/access/lookupfields.htm

2. Don't use the multi-value field property:

http://www.theregister.co.uk/2006/07/18/multivalued_datatypes_access/

 

[georgedwilkinson]

With that said, how can we help you solve your problem. It sounds like the structure you are referring to is a typical 1:M relationship that can be resolved by a form with a sub-form or a form with a combo-box with a query on the other table as the source.

 

[rlbroerman]

multiple values

My question still is Why does the HELP example show "Allow Multiple Values" and my Access 2007 does not shoe it in the Field Properties of the table?

1. Don't use lookups at table level:
http://www.mvps.org/access/lookupfields.htm

2. Don't use the multi-value field property:

http://www.theregister.co.uk/2006/07/18/multivalued_datatypes_access/

 

[boblarson]

If you go to the table, open in design view, select the field, go down to the bottom of the window to where the tabs say "GENERAL" and "LOOKUP" it is under the "LOOKUP" tab.

 

[rlbroerman]

multiple values in a form

You are correct. I had not been saving my database in 2007. When I did then "allow multiple values" showed up. Thanks for the help.
M
Now how do I use this in a form so I can select multiple items from a lst and put into a table.
Rick B

If you go to the table, open in design view, select the field, go down to the bottom of the window to where the tabs say "GENERAL" and "LOOKUP" it is under the "LOOKUP" tab.

 

[boblarson]

Again, I would highly suggest that you do not use the multiple values and set it up properly using a junction table and subform. Just because something CAN be done doesn't mean it should be.