Function Call from properties window

[Mark]

This may be a duplicate post. If so I apologize.

Here's what I'm doing:


Function CheckNumber(dblNumber as Double) as Boolean
CheckNumber=True
If dblNumber > 999 or dblNumber < -999 then
msgbox("Error")
Cancel=true
CheckNumber=False
End If
End Function


My function call within the properties window:
Before Update -
=CheckNumber([controlName])


I need the control name to be the control that I'm on. I could put
this function call in all my controls and change the control name
everytime, but isnt't there a way to pass the value of the control that

triggered the event? Something like =CheckNumber(Me.Control)


- Mark

 

[Douglas J Steele]

Look into ActiveControl in the Help file.

 

[Mark]

Thanks. I'll check it out.

- Mark