On Report Open Help

[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

 

[Rick Brandt]

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.

The Open event might be too soon. Try using the Format event of the section
where txtBox resides.

 

[Guest]

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.

 

[mattc66 via AccessMonster.com]

That was it - Thank you

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.

I have in my OnOpen Event the following:

[quoted text clipped - 8 lines]

Matt