check whether a field has changed?

[spinkung]

Hi

i have an OnExit event from a text box in a subform (bound) that insert's the record into another table. Can i check whether the field being exited has changed from it's original value?? If the value hasn't changed i don't want to run the insert.


Thanks

 

[boblarson]

1. Don't use the On Exit event.

2. Use the Before Update event. It won't fire unless something has changed.

 

[gemma-the-husky]

but controls have an old value property

you can say something like (in the beforeupdate event)

if textbox=textbox.oldvalue then
   'code to ignore this ...
end if

 

[boblarson]

but controls have an old value property

you can say something like (in the beforeupdate event)

if textbox=textbox.oldvalue then

[B]  'code to ignore this ...[/B]
[B]end if[/B]

Now, while that is true - the OP just asked:

If the value hasn't changed i don't want to run the insert.

and therefore, simply using the Before Update should be simple enough because it won't fire if nothing has changed. The same goes for the control's Before Update event. The form's Before Update event would be dependent on ANY change to a bound field on the form whereas the CONTROL'S Before Update event would deal explicitly with that control.

 

[gemma-the-husky]

i am not sure about that, bob

i thnik if you edit a control, but leave it unchanged, it still dirties the record - and you still get an update process.

 

[boblarson]

Yeah, I guess even if you change it back to the old value it does go through that. So you are right, you would need to use

If Me.ControlNameHere.OldValue <> Me.ControlNameHere Then
       ' Do something here to notify of a change
End If