ListBox concatenation

[Mick]

Hi

Am trying to use two listboxes. LB1 (say) holds the result of choices
on dblClick made in LB2.

I would like to be able to select several options in LB2 and display
them LB1 but am having difficulty as the second selection overwrites
the first.

VB uses a 'multiline' property but don't know an equivalent in Access
VBA.

Any help appreciated

Mick

 

[Matthias Klaey]

Hi

Am trying to use two listboxes. LB1 (say) holds the result of choices
on dblClick made in LB2.

I would like to be able to select several options in LB2 and display
them LB1 but am having difficulty as the second selection overwrites
the first.

VB uses a 'multiline' property but don't know an equivalent in Access
VBA.

Any help appreciated

Mick

The corresponding property in Access Listbox is "Multi Select", with
the options "None" (default, just one item can be selected), "Simple"
(a contiguous list of items can be selected with Shift+Click), and
"Extended" (selection of any combination of rows is possible with
Shift+Click and Ctrl+Click). To find out what the user selected, work
with the ItemsSelected property of the listbox in the listox'
AfterUpdate event.

HTH
Matthias Kläy