 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / May 2008I want to set up a multivalue list in Access 2007
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? 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).  SignatureAlbert D. Kallal (Access MVP) Edmonton, Alberta Canada pleaseNOOSpamKallal@msn.com 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. Signature--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 >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? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.