Printing Forms with multiple tabs

M

malvernbill

I've created a form to enter survey data, it is nine pages long. When I try
to print the form, it only prints the first page of each record. How can I
print out all nine pages for each record as it is completed?
 
M

malvernbill

Thanks John,

Appreciate your pointing me towards reports vs. forms. I have since created
a report and the command button to open the report. However, I am still at
the source of my initial question. I would like to print out the results of
my form.

At this point I'll substitute 'report' for 'form' and the initial question
remains essentially the same. For each new record, I enter data on nine
different tabs. When the report is generated, it is currently only for the
tab highlighted, and that particular tab for every record (there are
presently 8 records, when I print out tab#1, the tab#1 for all 8 records
print.

How can I enable Access to print tabs 1 through 9 for the record currently
selected?

Bill
 
J

John Vinson

Thanks John,

Appreciate your pointing me towards reports vs. forms. I have since created
a report and the command button to open the report. However, I am still at
the source of my initial question. I would like to print out the results of
my form.

At this point I'll substitute 'report' for 'form' and the initial question
remains essentially the same. For each new record, I enter data on nine
different tabs. When the report is generated, it is currently only for the
tab highlighted, and that particular tab for every record (there are
presently 8 records, when I print out tab#1, the tab#1 for all 8 records
print.

How can I enable Access to print tabs 1 through 9 for the record currently
selected?
Click to expand...

Base the Report on a query which selects the nine records - or nine
sets of fields, I have no idea how your table is structured - from the
Table (or tables). The Query can reference the name of the control on
the Form bound to the primary key field as a criterion - e.g.

=[Forms]![YourFormName]![SomeControlName]

Again: bear in mind that the data resides IN THE TABLES and only in
the tables. It's not "printing out tab#1" because there is nothing IN
tab#1; there is nothing in the Form. The record is stored in your
Table, using the Form and its tab control as a way to get it into the
table! You may need to explicitly save the record to disk in the
print-report command button code, using a line

DoCmd.RunCommand acCmdSaveRecord

before the OpenReport line.

John W. Vinson[MVP]
 
Top