Need to be able to set a value in record and have the old record available somewhere

[xzitstech]

Hello all! Relative newbie here, I haven't been able to find a way to make it so when I change a value in a record it still has the whole old record available for reference .
basically need a history but for a whole record then need to be able to add that to another modifier table for total values.

Any advice would be gladly welcomed!

[ranman256]

you can always write a new record to both tables: main & archive.

[CJ_London]

depends on whether you want your archive table to hold the current view and history or just the history

you can do something like this

in the current event create a sql string for a query which will insert the field values into your archive table - don't execute it
it will look something like 'INSERT INTO tblArchive (fld1, fld2) VALUES (fld1, fld2)'

in the form before or after update event, execute the sql string

alternatively you can build and execute the string in the form beforeupdate event - but referencing the control oldvalue properties instead.