Just wondering how best this might be done.
Controls on my Form are bound to a query. When (if) they're updated I want to show any changes before they're applied.
As I understand it, the data is only updated when the Form is closed, or moved to a new Record, or Me.Dirty= False is applied.
So data can change on the Form and the underlying table isn't updated (yet)?
If correct my thinking was to open a recordset to the Forms Record Source and compare each field and its control value in a loop.
Can I use a loop index or the control names ? Or is this the wrong approach altogether?
Controls on my Form are bound to a query. When (if) they're updated I want to show any changes before they're applied.
As I understand it, the data is only updated when the Form is closed, or moved to a new Record, or Me.Dirty= False is applied.
So data can change on the Form and the underlying table isn't updated (yet)?
If correct my thinking was to open a recordset to the Forms Record Source and compare each field and its control value in a loop.
Can I use a loop index or the control names ? Or is this the wrong approach altogether?