Report Header Printing Error

[Joe]

Hello,

I am having a problem with the OnPrint event handler in my
report header section. My code is below:

Private Sub ReportHeader_Print(Cancel As Integer, PrintCount As
Integer)
Dim ClientName As String

ClientName = CStr(Me.BusName)

 

[Guest]

Try using this instead:

ClientName = Cstr(Me!BusName)

using the BANG operator to refer to the FIELD name and not the control name.
--

Bob Larson
Super Moderator - Access World Forums
Access VIP on Utter Access
____________________________________
Access 2000, 2003, 2007, SQL Server 2000, Crystal Rpts 10/XI, VB6
WinXP, Vista