Using Ctrl Key to Select Multiple Values

[ajwgis]

I have created a form that contains data from two tables. Each drop down on the form, for each table, contains multipl values. I want to be able to make multiple selections from each down (usually this is holding down the ctrl key and making multiple selections). However; this method does not work in Access. Is there a way to select multiple values at one time in Access similar to holding down the ctrl key?

 

[billmeye]

If you are using a combobox or listbox control that is bound and you would like to have multiple selections you need to adjust the field in the table. Open the table in design view, select the field. It needs to be data type Text. On the lookup tab make sure it is set to combobox. You will see 'Allow Multiple Values', set this to yes and you will be able to select multiple values. Not by using Ctl key but by selecting check boxes in the control.

If you have an unbound listbox (not combobox) control, open the form in design view, select the control, on the Other tab you will see 'Multi Select'. Set this to either simple or complex and you will be able to have multiple selections.

 

[ajwgis]

1. Hey, THANKS! I'll give it a shot