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
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
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?
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
Glad it worked out for you. Good luck with the project.