I created a db.
In access I created a form also.
This form contains a listbox wich contains (a part of) al db records.
With a textbox and VB I creates a realtime search in the db.
After every character given in the textbox the listbox contains only the recors who contains the search patron.

Sofar it works realy cool.

However when I click on the listbox I select the row I click on and that's also as I want.
I want that when I leave (or lost focus on) the listbox, this selection will be deselected (and the selection mark will despare.

Someone told me that list.selected(list.listindex)=false must do the job.
Howerver I see the value of list.selected(list.listindex) and that is 0 and stays 0.
The give command must set it to -1. Wich is the value of al the other items of the listbox.

Can someone help my out?

Perhaps you could create an event that will refresh the listbox when it loses focus?

Something like this:

Private Sub "YOUR LISTBOX NAME"_LostFocus()
DoCmd.Requery
End Sub

or

Private Sub "YOUR LISTBOX NAME"_LostFocus()
DoCmd.RepaintObject
End Sub

Have you tried this yet?

Shane

hi toospeter,

The List.Selected... method only works with Checkbox Lists - From what you are saying, you are using a standard
ListBox yes?

If so, try (Shane was on the right track) Hope this helps.
Regards,
Rob


<center>"Nothing can stop the man with the right mental attitude from achieving his goal;
nothing on earth can help the man with the wrong mental attitude".
Thomas Jefferson</center>