subform viewing

[GAR]

When I create a subform, it is "pasted" on top of the related form. Is there
a way to only view selected subform(s) by way of a button control and then
toggle back to the main form?
I would like to set up several subform tabs at the bottom of my form similar
to the sheets tabs on the bottom of an Xcel file.

 

[tina]

well, that's what a subform is: a form embedded inside of another form.
it's usually the best and easiest-to-set-up way to display/enter related
data in multiple tables.

if you open a form, and then want to open a separate form to display related
data: get rid of the subform control in the main form. set a macro or VBA
code on a command button in the main form, to open the separate form; if you
want to display a subset of related records in the second form, you need to
filter the form's RecordSource. that's commonly done with a WHERE clause in
the OpenForm action.

hth