Click to See Complete Forum and Search --> : Simple Access listbox question


mojo
July 29th, 1999, 08:06 PM
I've got a listbox with the multiselect prop. set to "simple" in Access 97. If you select items in the listbox and then go to another form, and then come back to the form with the listbox, the items are still checked.
How do I get the listbox to refresh itself on Form_Activate or Form_Load so that no items are checked when it appears? Thanks in advance.

freek
July 30th, 1999, 02:34 AM
try this

private Sub Form_Activate()
Dim i as Integer
for i = 0 to List0.ListCount - 1
List0.Selected(i) = false
next i
End Sub