Help with report header from VBA

[Linus_99]

Hi,

I'm generating a report (Report1) from a VBA module with:

DoCmd.OpenReport reportname:="Report1", view:=acViewPreview, wherecondition:=strWhere

I have a caption string (strDesc) that I would like to put on the report and on the preview.

I can put the string on the title bar of the preview with:

Reports![Report1].Caption = strDesc

Can anyone please advise how I can put this string in the page header of the report, or in the report header of the report ?

Any advice would be appreciated.

 

[smozgur]

Hi Linus_99,

Declare strDesc variable in Form declaration section and as Public:

Public strDesc As String

Create a textbox on the report page header and change its ControlSource property as following (Assuming your form name is Form1)

=[Forms]('Form1').[strDesc]

I hope it helps.
Suat