Multiselect listbox

[liam_conor]

Using an add data form and a listbox...

Is it possible for multiple items to be selected in a listbox and those multiple items are returned to the database? Any examples?

 

[liam_conor]

Basically what I need to do is...

The user will select multiple items from a multiselect list box on a form and click on a command button. At that time the values that were selected in the multiselect list box will be stored in a temporary variable. A textbox, on the form, value will be set to this temporary variable. When the user cilcks another command button the value in the textbox will be sent to the database. Any examples?

 

[Dugantrain]

I know that there's a Multi-Select Option in the Combo's Properties. Never used it before, I don't know if by default it would treat each selection as a separate entity or if you could capture it all in one variable. Either way, I'm sure that you could write a pretty simple function to send the results to a table.

 

[Dugantrain]

"List boxes also have a MultiSelect property that allows the user to select multiple items from the control. When multiple selections are made in a list box, you can determine which items are selected by using the Selected property of the control. The Selected property is an array of values from 0 to the ListCount property value minus 1. For each item in the list box the Selected property will be True if the item is selected and False if it is not selected."

-Access VBA Help Files

 

[liam_conor]

I am new to VBA for Access. Could you elaborate? I have looked online, using Google, but I cannot find simple examples of VBA code for Access. I can find tons of examples for Excel but not for Access.

 

[Dugantrain]

http://www.access-programmers.co.uk

is a fine place to start. A bit more advanced too, I would think that someone will know about Multi-picks a bit better.

 

[liam_conor]

Sloncha!