speed with tab controls

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database written with Microsoft tab controls, with subforms on subsequent tabs. When I split the database after development, the speed to open the form with the tab controls went from 1 sec to 2.5 minutes. Note: There is virtually no data in the tables. Only sample info to test. The main tab is based off a table, the second tab with subform is also based off a table with a link to the mail record.

Has anyone had difficulty with this? I have written the same program in both 2000 and 2002 to see if the issue was fixed in the newer version but no luck

What I was hoping to do was to have all the subforms to not have a record source until a quote is chosen on the header. Is this possible

Thank you in advance for your time.
 
Jackie L said:
I have a database written with Microsoft tab controls, with subforms
on subsequent tabs. When I split the database after development, the
speed to open the form with the tab controls went from 1 sec to 2.5
minutes. Note: There is virtually no data in the tables. Only
sample info to test. The main tab is based off a table, the second
tab with subform is also based off a table with a link to the mail
record.

Has anyone had difficulty with this? I have written the same program
in both 2000 and 2002 to see if the issue was fixed in the newer
version but no luck.

What I was hoping to do was to have all the subforms to not have a
record source until a quote is chosen on the header. Is this
possible?

Thank you in advance for your time.
Click to expand...

First, make sure you have the Name Autocorrect option turned off. My
guess is that is the source of your problem. If that alone doesn't fix
your performance problem, You can clear the SourceObject of the subforms
on non-visible tabs, and only set the SourceObject of each subform in
the tab control's Change event -- the tab control's value is the
PageIndex of the page that is now visible, so you can set the
SourceObject of the appropriate subform and clear the SourceObject of
the subform that has now been hidden by the page change.
 
Back
Top