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?
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?