Deselect or remove highlight from item in listbox (1 Viewer)

[magster06]

Hi All,

I am using Access 2010.

I have a form with three listbox. My issue is this, when I go from listbox to listbox the selected item in the previous listbox is still selected.

I would like it so when I go to the new listbox, then the previous listbox selection will no longer be highlighted.

I use the follow code, which works but the user has to double click on the listbox with the focus to make a selection, very frustrating.

Me.listbox.listindex = -1

I have the code in the lost focus event of the listboxes.

Is there a way to prevent the double clicking?

I hope that I am making sense with this; sorry if there is any confusion.

 

[vbaInet]

Try the Selected property.

 

[magster06]

vbaInet,

Thank you for your response! I am not sure exactly how to use the "Selected" property.

I have tried:

Me.lst1UnitAlt.Selected(0) = False

but I still have to double click on the next listbox.

When I use:

Me.lst1UnitAlt.Rowsource = ""

Then this clears my listbox (which it should).

Am I to reload my listbox with a sql after it is cleared?

Sorry for my ignorance

I have attached an image of what the listboxes. In the image you can see that an item is selected in the first and second box. What I would like is when I click on the second or third listbox, then the selected item in the previous listbox with deselect.

 

[vbaInet]

Double click for it to be highlighted? I think what's happening there is the first click sets the focus and the second click highlights a row. Try running the code in the Got Focus event of the listbox but this time deselect the other two listboxes.

You shouldn't need to keep clearing the Rowsource.

 

[magster06]

Double click for it to be highlighted? I think what's happening there is the first click sets the focus and the second click highlights a row.

Yes, I believe that is what is happening.

 

[vbaInet]

So have you tried what I suggested?

 

[magster06]

vbaInet,

Your idea worked!

I placed the following in the GotFocus event of the listbox that I would be making a selection in:

Me.listbox that I am leaving.Selected(0) = False

Thanks again vbaInet!

 

[vbaInet]

Good stuff!