ListBox lost focus on CLICK event - Jumps off the selected record

[Kody_Devl]

Hi All,



I have a list box on a form with 10 items showing.

If I click on item #6 of 10, the focus will jump from #6 to the first record.

What vba code can I add so the focus will remain on Item #6 after I click it?

Many Thanks

Kody_Devl

[davegri]

Sounds like the listbox onclick event is requerying the listbox.
Not much for us to go on. What is the purpose of the listbox and what do you want to happen when item 6 is clicked?
What code is in the on_click event?

[Kody_Devl]

davegri

Your question inspired me consider the Click event.
Buried in the event is a sub-routine call "Requery_Form".
I commented out Me.lstbox.requery and solved the problem.

I humbly thank you .


Kody_Devl

[davegri]

Glad it worked out for you. Good luck with the project.