I need to add modification tracking to an existing database. It's effectively the same as the std. Orders/Order Details model so I'll use that for an example.
If a user makes a change to an existing order I need to be able to deactivate the original record and generate a new Order record. The same goes for any Order Details that are also changed. The idea is that users should be able to view what an Order looked like at a particular point in time.
If I create a standard Edit Order form with a linked Order Details subform then the records get updated whenever the user moves from Order field to Order Details field and from row to row in the Order Details subform. I would like to allow the users to make all changes to an 'Order' and then perform the save allowing me to code for the modification tracking records - tracking what changed during a user's session with the Order.
I don't want to just add code into the BeforeUpdate event as I can see a user making several changes to the Order Details rows, changing them back, and then I'd have historical records showing no changes or I compare all Updates against existing records looking for changes field-by-field.
Is there a way to disable/delay updates on a bound subform so I can act on everything being updated at one time?
Thanks in advance for comments/suggestions!
If a user makes a change to an existing order I need to be able to deactivate the original record and generate a new Order record. The same goes for any Order Details that are also changed. The idea is that users should be able to view what an Order looked like at a particular point in time.
If I create a standard Edit Order form with a linked Order Details subform then the records get updated whenever the user moves from Order field to Order Details field and from row to row in the Order Details subform. I would like to allow the users to make all changes to an 'Order' and then perform the save allowing me to code for the modification tracking records - tracking what changed during a user's session with the Order.
I don't want to just add code into the BeforeUpdate event as I can see a user making several changes to the Order Details rows, changing them back, and then I'd have historical records showing no changes or I compare all Updates against existing records looking for changes field-by-field.
Is there a way to disable/delay updates on a bound subform so I can act on everything being updated at one time?
Thanks in advance for comments/suggestions!