P
PC User
I'm using an agency form in the background to make my report. Its a MS
Word OLEUnbound on which I placed the data fields to fill in the
agency's form. The form has a table where a list of chemicals needs to
fit into. There are twelve rows to this list and when the list exceeds
12 I have the subform create a page break.
On the first page of the report the subform lists the first 12
chemicals on the agency's form and then makes a page break. The
problem is that the lists on the following pages are on the top of the
page and the agency form no longer appears on the following pages.
REPORT
rrsbcInventorySummary
SUBREPORT
rsubsbcinventorySummaryDetails
Code in SUBREPORT
================================
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me.yearCount = 50 Then
Detail.ForceNewPage = 2 ' after section
Else
Detail.ForceNewPage = 0 ' none
End If
End Sub
================================
I still need a subform to cycle through the records, but how do I
retain the agency form on all pages?
Thanks,
PC
Word OLEUnbound on which I placed the data fields to fill in the
agency's form. The form has a table where a list of chemicals needs to
fit into. There are twelve rows to this list and when the list exceeds
12 I have the subform create a page break.
On the first page of the report the subform lists the first 12
chemicals on the agency's form and then makes a page break. The
problem is that the lists on the following pages are on the top of the
page and the agency form no longer appears on the following pages.
REPORT
rrsbcInventorySummary
SUBREPORT
rsubsbcinventorySummaryDetails
Code in SUBREPORT
================================
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me.yearCount = 50 Then
Detail.ForceNewPage = 2 ' after section
Else
Detail.ForceNewPage = 0 ' none
End If
End Sub
================================
I still need a subform to cycle through the records, but how do I
retain the agency form on all pages?
Thanks,
PC