SUBFORMS

  • Thread starter Thread starter Martine Lamusse Guest
  • Start date Start date
M

Martine Lamusse Guest

Hi

I am trying to create forms with subforms in wizzard and
am unable to do so. It does not want to give me the
select subform page at all it just creates one form with
all the information on it. It is driving me crazy. Not
only is it my first attempt at Access now I can't go pass
the forms. Can someone please help me identify the
problem.

Thank you
 
Create a form and a subform at the same time.

Before using this procedure, make sure you've set up your
table relationships correctly.

In the Database window, click Forms under Objects.

Click the New button on the Database window toolbar.

In the New Form dialog box, double-click Form Wizard in
the list.

In the first wizard dialog box, select a table or query
from the list. For example, to create a Categories form
that displays products for each category in a subform,
select the Categories table (the "one" side of the one-to-
many relationship).

Double-click the fields you want to include from this
table or query.

In the same wizard dialog box, select another table or
query from the list. Using the same example, select the
Products table (the "many" side of the one-to-many
relationship in the Categories form example).
Note It doesn't matter which table or query you choose
first.

Double-click the fields you want to include from this
table or query.

When you click Next, if you set up the relationships
correctly before starting the wizard, the wizard asks
which table or query you want to view by. Using the same
example, to create the Categories form, click By
Categories.

In the same wizard dialog box, select the Form With Subform
(s) option.

Follow the directions in the remaining wizard dialog
boxes. When you click Finish, Microsoft Access creates two
forms, one for the main form and subform control, and one
for the subform.

this was copied directly out of the Access help files.
hope it helps.

lee.
 
Back
Top