Form troubles

[Jody]

I am having a troublesome problem with a form I designed.
Basically there are 2 forms involved and 8
subforms/queries.

Form A - main data entry form set up by ID NUMBER and
then STAND#
Form B - pop up screen only - shows calculations based on
total individual
trees per species which is filled in by the following 8
subforms.
8 subforms in Form B - each one is a query that counts
the number of trees
per species that are in a specific size criteria (ABB
<25, ABB 26-36, ABB
38-48, ABB >50, ACC <25, ACC 26-36, ACC 38-48, ACC >50)

Here is the scenario:

Problem #1: I have a button on FormA that opens up FormB
(with the 8
subforms) and fills in the fields automatically for me.
I can get the
form to pop up with the 8 required subforms filled in
correctly but when I
go to print the form it prints out a duplicate of the
original form 8
times. I assume somewhere in my links is the problem but
I am unsure.

Here is the linking:
The main form (FormA) has a button that produces a pop up
screen that asks
which STAND# you wish to query on (there can be up to 20
per ID NUMBER).
It then opens up the new form (FormB)linked by ID NUMBER
and STAND#.
Within FormB there are 8 subforms all linked to FormB by
ID NUMBER and
STAND#.
The 2 fields being used for linking are crucial and I can
not change them
to other fields.

Problem #2: The most critical problem as I see it...I
have to produce a
table that combines the results of the 8 subqueries so
that I can get it
out of Access and in to Excel - am I trying to do the
impossible?


Any help would be greatly appreciated.

Jody

 

[Joan Wild]

correctly but when I
go to print the form it prints out a duplicate of the
original form 8
times.

You should create a report to print your information. Forms really aren't
meant for printing.

You can create a report and use subreports, similar to how you created your
form.