after update event only when control was b4 null

Z

zionsaal

I have a control in a form and I want a msgbox to pop up after users
modify the value in the control but I want the msgbox should not pop
up if the control was before a null or a 0 value
it should only pop up when he modify it

how can i do that?
 
R

Rick Brandt

I have a control in a form and I want a msgbox to pop up after users
modify the value in the control but I want the msgbox should not pop
up if the control was before a null or a 0 value
it should only pop up when he modify it

how can i do that?
Click to expand...

If Nz(Me.ControlName.OldValue, 0) <> 0 Then...
 
Top