Header On Each Page

CMontoro

Registered User.
Local time
Today, 15:33
Joined
Mar 26, 2005
Messages
21
I've designed a report with a header which has a special title that it depends on a previous form's textbox
In the header page I used a textbox with:

=Forms![formname]![controlname]

This works fine on the first page. However next pages displays an error:
# name
I need show the title on every page.

Thanks in advance,
CM
 
Make sure the form stays open.
 
similiar problem with textbox in report

Hi Paul.
Thanks for your advice.
I've created a form and a report with:

Form: frmTest
Texbox: monthx
Texbox yearx

Report: infTest
Textbox: period

If I would show in the report, for example: "February / 2006" , (the concatenation :monthx+yearx)

In the report's Open event procedure:

Private Sub Report_Open(Cancel As Integer)
Me!period.ControlSource = "='" & Forms!frmTest!monthx & "'" + "/" & Forms!frmTest!yearx & "'"
End Sub

but It gave me a sintaxis error.
Please help me
Thaks in advance
CM
 

Users who are viewing this thread

Back
Top Bottom