Unloading Subforms

[Geoff Codd]

Hi there,

I have a Main form which has 10 subforms on tab controls, I want to speed up the database so that the subforms only load when you select the tab.

thanks
geoff

 

[Sohaila Taravati]

To begin with, using tabs will slow you down. I had the same problem with one of my forms that had tabs and only 4 subforms and it was very slow for the form to open up. So what I did was that I got rid of the tabs and put in buttons instead. The user didn't even noticed it was changed! I also put a code behind each button, so when it's pressed it will make the other forms not visible.