Changing Report title according to form data

[Jahappz]

Hello!

I have a report that i want to have the "title" to be
according to a field in a form that i have.



eg. enter "TEST" in the form and the "title - caption" should be "TEST" in the report.

is this possible?

 

[Remou]

You can set the title in the form's open event:

Private Sub Report_Open(Cancel As Integer)
Me.lblTitle.Caption = Forms!frmF!txtName
End Sub

Or you can use a textbox and refer to the form in the Control Source:

= Forms!frmF!txtName

 

[Jahappz]

Ms VB complains about the ".lblTitle"

when running the report any idéas?

 

[Remou]

Yes, change lblTitle and the name of the form to the names that you have used.

 

[Jahappz]

Private Sub Report_Open(Cancel As Integer)
Me.Caption = Forms!frmF!txtName
End Sub

Worked for me!

Big thanks!