use dLookup as boolean to set visibility variable?

Banaticus

Registered User.
Local time
Today, 12:11
Joined
Jan 23, 2006
Messages
153
I'm trying to say something like:
If (there is at least one record of this type in the form) Then
turn variable on
else
turn it off
end if

If DLookup([Note], [Problem Info], [SocSec] = Forms![Apprentice Information]![Soc Sec #]) Then
problemImage.Visible = True
Else
problemImage.Visible = False
End If

Any suggestions?
 

Users who are viewing this thread

Back
Top Bottom