Is there an On Previous (opposite of On Current) Event?

[sambo]

Is there a way to grab the data from a form BEFORE the On Current Event.

i.e. when the record changes, I want to gather unbound data from the form BEFORE the record changes (the old data on the form, not the new data coming in).

 

[llkhoutx]

There's no OnPrevious event.

Try the form Before Update event, this event fires immediately prior to a record being saved.

Because you are using an unbound form, you know exactly when data is being re-entered into the form.

Are you resetting all fields in the form before "bringing in" new data? Save the current value in the tag property as it is entered, so if no data is entered, you can retrieve the "previous value" from the tax.

 

[llkhoutx]

There's no OnPrevious event.

Try the form Before Update event, this event fires immediately prior to a record being saved.

Because you are using an unbound form, you know exactly when data is being re-entered into the form.

Are you resetting all fields in the form before "bringing in" new data? Save the current value in the tag property as it is entered, so if no data is entered, you can retrieve the "previous value" from the tax.

 

[sambo]

Its kind of a tricky form, since it is actually a subform. The form itself is bound to a query which pulls from 3 seperate tables (which is a pain in itself when trying to do Ref. Inegrity), there is a subform within the subform, however, that has 2 unbound fields that I would like to track values of.

So... when the record changes on the top-level subform, I would like the data in an unbound field of the sub-subform to be logged in a table.

This is why I need some sort of On Previous Event, so I can change the value in a table that corresponds to an unbound field in the sub-subform each time the main record is switched.