If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Multi Value Combo Boxes
Hello:
One of the new features of Access 2007 (sometimes criticized) is the ability to create a table field as "Allow Multiple Values" using the Lookup Wizard when specifying the data type. This shows the values with a checkbox and allows the user to select multiple items (i.e. select CA, OR, WA as states in which a business resides). I was hoping to just define a table field as Text and then create the "Allow Multiple Values" when creating a combo-box on the form. The form wizard does not seem to create the same objects as when doing it in table design mode. So, unless someone knows how to create these "Many to Many Under the Cover" relationships in forms, I will probably have to do that functionality in the table design mode. I am familiar with the usual list box ability to select multiple items into a collection, but that is available in Access 2003. This new feature is only in 2007, and I'm not sure how to invoke it from a form. Ideas? -- Rich Locus Logicwurks, LLC |
Thread Tools | |
Display Modes | |
|
|