On Report Open Help

  • Thread starter Thread starter mattc66 via AccessMonster.com
  • Start date Start date
M

mattc66 via AccessMonster.com

I have in my OnOpen Event the following:

If CntlName = "XYZ" Then
Me.txtBOX = "ZYX"
End If

When I open the Report it say the CntlName has no value. However it does,
because if I remove this code the CntlName shows up on the Report.

Help!

Matt
 
mattc66 said:
I have in my OnOpen Event the following:

If CntlName = "XYZ" Then
Me.txtBOX = "ZYX"
End If

When I open the Report it say the CntlName has no value. However it
does, because if I remove this code the CntlName shows up on the
Report.
Click to expand...

The Open event might be too soon. Try using the Format event of the section
where txtBox resides.
 
You can't use the OnOpen event of the report. Try place your code in the On
Format event of the section of the report that contains the control.
 
Back
Top