Attempting to refresh a selection in a Multi-Selection List Box

[alex35]

I am attempting to remove highlighted selections on a multi-selected list box when the form where the list box resides is refreshed. I am using Access 2003.

The following is the coding that is being used:

Me!mylistbox.Value = Null

This code works fine as long the list boxes does not have the multi-selection option invoked.

Any guidance you can provide would be much appreciated.

Thanks in advance,
alex35

 

[PHV]

You may try this (typed, untested):
Dim savRS As String
With Me!mylistbox
savRs = .RowSource
.RowSource = ""
.RowSource = savRS
End With

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[alex35]

Beautiful. Worked like a charm.

Thanks again,