Speed up form loading

[KentJ]

Looking for good ideas others have used.

I have a form with a tab control on it (8 tabs) spread across the tabs are about a half-dozen data controls. When the form loads, all the data controls operate and it takes the form a while to load. I would prefer the queries to occur when the specific tab is highlighted.

One option is to bring all the data controls into code, this isn't so difficult, but it loses the "elegance" of the visual controls.

Anybody thought about this? Any ideas????

[Brent Akester]

That's alot of data controls. No wonder it's slow to load. I would recommend you use either DAO or ADO, and get rid of the data controls. It means more coding, and you'd need to create your own navigation buttons to navigate through your data, but in so doing you could use the same navigation function for all your tabs, thus eliminating all the redundant controls and code.