Box to apear in Subform

[Simon]

I have a report with a subreport that shows products in a list and i
would like a box to aprear next to it if a product code is displayed

I have the following VB code but can not get it to work

Private Sub Report_Open(Cancel As Integer)
If Me.ProductCode Is Null Then
Me.Box.Visible = True
End If
End Sub


Could any one tell me what i have done wrong

Thanks very much

 

[Pieter Wijnen]

try

If IsNull(Me.ProductCode.Value) Then

Pieter

 

[Tom Wickerath]

The report_open event procedure should fire only one time. If I'm
understanding your situation correctly, you have several products showing in
the detail section of a subreport. Have you tried placing your code in the
Detail_Format event procedure for your subreport?


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________