Tabbed pages

[a24t42]

I am working on increasing the speed of my database. I have a question
about using tabbed pages,which is slow to open.

I have it set up so that it has 10 tabs. This is a repair database so
each tab is some part of the process. For example, when it went to the
repair shop, when it is scheduled for repair, etc. My question is that
7 of the tabs are based on separate and different queries. When the
main form opens, does only the query that is associated with that page
run and the rest do not run until that tab is selected. Or, do all the
queries run? I hope that makes sense.

Thanks in advance.

 

[Baz]

They all run.

What I do to avoid this problem is to have one subform control, and above it
a row of command buttons in an option group. When a button is clicked, I
evaluate which one it is by using a Select Case statement on the value of
the option group, and I change the SourceObject of the sub form control to
show the appropriate form.

 

[a24t42]

Thank you for the quick reply. No wonder it was slow to open as I was
filtering about 3,000 records out of 140,000 times 7. WOW!

I have used your recommendation and set up an option group with command
buttons. So far so good. Now to the next item - getting it to open the
correct sub form when the button is pushed. Can this be done with
macros or do I have to write a module? My knowledge of VB is minimal.

Thanks.