large report

[Guest]

Hi all,

I am working on a form that have some data.. the data I have are send to a
premade report. Practically I have alot of fields inside this form and
normally would fit in the page of the report, but I have to spread them on 2
pages. How can this be done? I have to make 2 sepparate forms to be able to
make two report pages?
==========================================
On the form I have a "print" button that takes me to the report page. The
code is something like this:

Private Sub btn_click_Click()
On Error GoTo Err_btn_click

Dim MyWhereCondition As String

MyWhereCondition = "xxx= " & Me.xxx
MyWhereCondition = "xx= " & Me.xx
DoCmd.OpenReport " reportnamehere", acPreview, , MyWhereCondition

Exit_btn_click:
Exit Sub

Err_btn_click:
MsgBox Err.Description
Resume Exit_btn_click

End Sub
=================================================

So when I pres the "print" button, I want somehow to be able to print the
data from the form that are spread on the two report pages.

Thanks in advance,

Best regards,
I.H.

 

[Marshall Barton]

I am working on a form that have some data.. the data I have are send to a
premade report. Practically I have alot of fields inside this form and
normally would fit in the page of the report, but I have to spread them on 2
pages. How can this be done? I have to make 2 sepparate forms to be able to
make two report pages?
==========================================
On the form I have a "print" button that takes me to the report page. The
code is something like this:

Private Sub btn_click_Click()
On Error GoTo Err_btn_click

Dim MyWhereCondition As String

MyWhereCondition = "xxx= " & Me.xxx
MyWhereCondition = "xx= " & Me.xx
DoCmd.OpenReport " reportnamehere", acPreview, , MyWhereCondition

Exit_btn_click:
Exit Sub

Err_btn_click:
MsgBox Err.Description
Resume Exit_btn_click

End Sub
=================================================

So when I pres the "print" button, I want somehow to be able to print the
data from the form that are spread on the two report pages.

Forms do not contain data. Tables contain the data and a
form can be used to interact with the data in a table.

Generally, a form is bound to a table/query and when you
edit that data in the form, the data needs to be saved back
to the table before a report can access the new/modified
record. If this is your situation, use a line of code
before opening the report:
If Me.Dirty THen Me.Dirty = False
If that's not relevant to your situation, please explain
what you are doing.

To get a page break in a report section, insert a Page Break
control from the tool box.

 

[Guest]

The thing was more simpler than I thought. I didn't understand whre the page
brakes and starts another one (Like Microsoft Word in Print Layout view).
Page brake should do, or I can track where the text goes on another page.
Thanks for the help.