Iif statement and macro

[Soegstad]

Hello
I have a problem with an Iif statement.
I have a field which shows a percentage, and I want a message to pop up if the user enters a number lower or higher than a set integer. I have made a macro that does that actual popup, but how do I set up the Iif statement?
Thanks for your time
Mads

 

[Rich]

Much better to use vba and a message box

If Me.MyControl<.45 Then
MsgBox "Wrong value dummy"
End If

if you want to be able to prevent the update then post back

 

[Soegstad]

I'll do just that.
Thanks for your help.
Mads