>Hi Nadya:
>
>I had a similar problem designing a Nav bar because I wanted to detect user changes the moment they made them and immediately enable/disable the appropriate button(s).
>
>I discovered the Value property didn't change until Focus left the field. I had a solution along the lines of yours, and to detect the underlying value of the Table I used:
>
>
>oCurrentControl = THIS.oCurrentForm.ActiveControl
>IF oCurrentControl.Value <> Eval(oCurrentControl.ControlSource)
> Messagebox("Change made.")
>ENDIF
>
>
>As you can see I had to query the underlying ControlSource to detect changes.
>
>HTH,
>
>-Irv.
Irv,
Thanks for the reply. You should add a check to your code for the ActiveControl and .value property (similar as I did), because the ActiveControl could be a Commandbutton, or form could not have ActiveControl at all.
Thanks a lot again.
If it's not broken, fix it until it is.
My Blog