Multiple Subforms

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Hello again ...

Is it possible to have multiple subforms? I have the
following tables:

RMA Main (the main table)
Labor
Repair Parts

I would like to create a form where RMA is the main form
and there are two subforms -- one for Labor and one for
Repair Parts.

When I go through the Forms Wizard and select the fields
in the three tables, it does not allow me to have
subforms. The result is an empty form with no fields.
However, if I select only two of the tables, it will allow
me to have one of them be a subform.

Any help will be appreciated!

Mike.
 
Mike,

The simle answer is "Yex", but take a look in the help
file for "Subforms: What they are and how they work"

Part of this help topic says, "A main form can have any
number of subforms if you place each subform on the main
form. You can also nest up to two levels of subforms.
This means you can have a subform within a main form, and
you can have another subform within that subform. For
example, you could have a main form that displays
customers, a subform that displays orders, and another
subform that displays order details."

HTH

Byron
 
Mike,

I should have stated that in my first reply that the
information provided is relative to Access 97. It is a
little different for Access 2002. Here is part of
the "About subforms" help topic for Access 2002:
"A main form can have any number of subforms if you place
each subform on the main form. You can also nest up to
seven levels of subforms. This means you can have a
subform within a main form, and you can have another
subform within that subform, and so on. For example, you
could have a main form that displays customers, a subform
that displays orders, and another subform that displays
order details. However, a form will not display subforms
in PivotTable or PivotChart view."

HTH

Byron
 
Back
Top