Triggering an event based on two conditions
Thank you very much! It works beautifully.
Bob
"Stefan Hoffmann" wrote:
hi Bob,
Bob Waggoner wrote:
Actually, I'm using this for an employee survey. I want the employees to use
one of the numbers (drawn from a hat) to validate their participation in the
survey.
Create a table, where you store these numbers.
Then you may use e.g. DCount():
If DCount("*", _
"yourTable", _
"ValidationNum = " & [SurveyNumber]) 0 Then
'make the fields visible
End If
mfG
-- stefan --
|