Creating a list box where > 1 value is selected 1

[spkplf]

Using access 97, what is the easiest way to allow users to select > 1 value from a field on a form?

 

[GHolden]

Do you mean you want to select more than one item in a listbox??

If so, in the list box properties, go to the 'Other' tab and set the multi select property.



There are two ways to write error-free programs; only the third one works.

 

[spkplf]

that allows me to select more than 1 from the list box, however it is not saving my selections the next time I open the record.

 

[GHolden]

If you are using a bound form and set the listbox to multi select, the value of the listbox will always be null.

If you want to save the values you will need to loop through all the items in the list an write code to save the ones that are selected.

If your listbox was called for example lstName you can do this something like...

Dim intCount As Integer

For intCount = 0 To lstName.ListCount -1
If lstName.Selected(intCount) Then
'code to save record here
End If
Next intCount


There are two ways to write error-free programs; only the third one works.