List boxes

[Gargamil]

This is probably a simple request but how do I record multiple selections
from a list box in a table??

For each piece of equipment I'm selecting all the components that it has on
it from a listbox of all the standard components. So for each piece of
equipment there are multiple components. now once selected how do I record
this information back to the equipment table for each piece of equipment??

 

[Naresh Nichani MVP]

Hi :

Try this to read values which are selected --

Dim i As Integer

For i = 1 To Me.List2.ListCount
If Me.List2.Selected(i) Then
MsgBox Me.List2.ItemData(i)
End If
Next

Regards,

Naresh Nichani
Microsoft Access MVP