I have a Form with tab box of 6 pages, the default page apart, each of the other 5 pages has a listbox, and the SQL for each listbox is a bit heavy and can take the page a while to load
i have the code so that once i have opened a page, go to a different page, and go back in that page, the listbox in that page doesnt reload.
however, when i close the form, and then re-open the form, each listbox loads from the its rowsource SQL which causes the form to fully open very slowly into the default tab page
i have tried setting the rowsource for each listbox to "", for when i close the form, but this doesnt work
is there a means of emptying the listbox when i close the form, so they dont load until i enter the page the next time i open the form
thank you in advance
i have the code so that once i have opened a page, go to a different page, and go back in that page, the listbox in that page doesnt reload.
however, when i close the form, and then re-open the form, each listbox loads from the its rowsource SQL which causes the form to fully open very slowly into the default tab page
i have tried setting the rowsource for each listbox to "", for when i close the form, but this doesnt work
is there a means of emptying the listbox when i close the form, so they dont load until i enter the page the next time i open the form
thank you in advance