Simple Access listbox question
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.
Re: Simple Access listbox question
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