after update event only when it was null

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

 

[Alex Dybenko]

hi,
if this is a bound control - then you can use beforeupdate event and check
control's .OldValue property for null or 0

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[zionsaal]

hi,
if this is a bound control - then you can use beforeupdate event and check
control's .OldValue property for null or 0

--
Best regards,
___________
Alex Dybenko (MVP)http://alexdyb.blogspot.comhttp://www.PointLtd.com







- Show quoted text -

thank you Alex !