loading forms quicker (1 Viewer)

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

Hi. One way is to go to Design View and remove the RowSource from your Listboxes. Then, in the Change event of your Tab Control, you can assign the RowSource of the Listbox on that page.