F
FA
Hi, I have a report which has a label called Screenshots. I want this
label to be visible only if there is any screen shot for a particular
FINDG_NO. below is my code that i put in the detail section of OnFormat
event. its giving me the error that you canceled the previous action.
Can somebody help me out please
Dim stLinkCriteria As String
stLinkCriteria = "[FINDG_NO]=" & Me![FINDG_NO]
If DCount("*", "dbo_ScreenShot", _
stLinkCriteria) > 0 Then
Me.Screenshots.Visible = True
Else
Me.Screenshots.Visible = False
End If
Thanks
Moe
label to be visible only if there is any screen shot for a particular
FINDG_NO. below is my code that i put in the detail section of OnFormat
event. its giving me the error that you canceled the previous action.
Can somebody help me out please
Dim stLinkCriteria As String
stLinkCriteria = "[FINDG_NO]=" & Me![FINDG_NO]
If DCount("*", "dbo_ScreenShot", _
stLinkCriteria) > 0 Then
Me.Screenshots.Visible = True
Else
Me.Screenshots.Visible = False
End If
Thanks
Moe