report/vba problem

[tope12 via AccessMonster.com]

Im trying to write some code into the header part of a report on the format
event. I keep getting an error message that says that it cant find the field
"NBA". I even specified the table it was in (budget.nba.value) and it still
gives me the same error.
Does anyone know what i did wrong?


Private Sub PageHeaderSection_Format(Cancel As Integer, FormatCount As
Integer)

If employee_department = "NBA" Then
Text67 = NBA
End If

End Sub

 

[Marshall Barton]

Im trying to write some code into the header part of a report on the format
event. I keep getting an error message that says that it cant find the field
"NBA". I even specified the table it was in (budget.nba.value) and it still
gives me the same error.
Does anyone know what i did wrong?


Private Sub PageHeaderSection_Format(Cancel As Integer, FormatCount As
Integer)

If employee_department = "NBA" Then
Text67 = NBA
End If

End Sub

If NBA is a field in the report's record source table/query,
you can do that, but you need to bind the NBA field to a
(invisible?) text box on the report.