Hopefully a simple one:
I'm trying to put together a simple before/after check on a continuous form's (frmActor) bound control (actorName), and then posting any changes to an audit table (tblModHistory).
When I make a change and hit either <TAB> or <ENTER>, the control values Me.actorName and Me.actorName.oldValue are set correctly and I can post these to the audit table.
However, when I make the change, and then click away from that row (either on another row or on a button that closes the form) I get either the same value in both or one of the values is retained from a previous row.
I have probably tried every combination of control event the correct one!
Where do I test the before and after values of the control to get the correct values, regardless of method of exit?
Thank you
I'm trying to put together a simple before/after check on a continuous form's (frmActor) bound control (actorName), and then posting any changes to an audit table (tblModHistory).
When I make a change and hit either <TAB> or <ENTER>, the control values Me.actorName and Me.actorName.oldValue are set correctly and I can post these to the audit table.
However, when I make the change, and then click away from that row (either on another row or on a button that closes the form) I get either the same value in both or one of the values is retained from a previous row.
I have probably tried every combination of control event the correct one!
Where do I test the before and after values of the control to get the correct values, regardless of method of exit?
Thank you