I want to set up a multivalue list in Access 2007

[Hobbits House]

I would like to set up a multivalue list in Access 2007. I'm following the
instructions from the Help section but I don't see the screen where it asks
me "Do you want to store multiple values for this lookup?" as stated in the
Help section. What do I do?

 

[Albert D. Kallal]

Add a new field to the table, and choose "lookup wizard" for the column
type.

The "last" question in this wizard will have a option to allow multiple
values....

When done, simply "display" the fields in design view for that form, and
then drop in that field into your form. You instantly see a dropdown box
with check boxes for that field.... (ms-access will create the multi-select
control for you).

 

[Roger Carlson]

You must be using the ACCDB format of Access 2007 in order to use multiple
value fields. Perhaps this is obvious, but since you didn't say, I thought
I'd point it out.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L