Selecting More than One from ComboBox List

[Guest]

Access 2003. I use a drop down combobox to select the value for a record in
a continuous form. I would like to be able to make multiple selections from
the drop down list (or something similar) and have it then generate multiple
records. For instance, say the list has A,B,C,D as its selections. I would
like to be able to select say A and D (for instance by holding down the ctrl
key) and have two records generated, one with A and the next with D. Perhaps
combobox is not the way to accomplish this. if not how may I accomplish
this? Thanks.

 

[fredg]

Access 2003. I use a drop down combobox to select the value for a record in
a continuous form. I would like to be able to make multiple selections from
the drop down list (or something similar) and have it then generate multiple
records. For instance, say the list has A,B,C,D as its selections. I would
like to be able to select say A and D (for instance by holding down the ctrl
key) and have two records generated, one with A and the next with D. Perhaps
combobox is not the way to accomplish this. if not how may I accomplish
this? Thanks.

I have no idea what you mean by generate two records, etc. but you can
not select more than one item from a combo box.

You can using a List Box set to MultiSelect (Simple or Extended).
You'll need code to cycle through the list and return the values
selected. Sample code is available in VBA help. Look up ItemData.

 

[SF]

Switch to Listbox
SF