Hi Laoballer,
If you put a subform on each page of the tab control, you can set the
recordsource of the subform to whatever query you want on each subform.
To display a form in tabular format, on the form's property dialog, the
format tab, default view, choose continuous forms.
To make the form with the tab control load quickly, you will want to have
code that sets the source object for a subform when that page of the subform
is clicked. You use the Change event of the tab control to do this.
Your subforms sit on each of the tab control, each subform has an empty
source object until a user clicks that page of the tabcontrol, then your
code tells the subform what form to use as its source object.
Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
