Full Version: Simultaneously show previous along with current record in the sa
UtterAccess Discussion Forums > Microsoft® Access > Access Forms
JJ1
Nov 25 2008, 05:54 PM
In a form I made I want to be able to see the previous changed, entered or viewed recordset along with the current or new recorset. What I've done is used the default access form wizard, added a few navigational controls and customized my layout. Then I simply copied the column of fields that I need to be able to see simultaneously and made them unbound.

After which I implemented the following code

CODE
Private Sub Form_BeforeUpdate(Cancel As Integer)

    Text140.Value = Text59.Value

    Text141.Value = Text61.Value

    Combo136.Value = Combo38.Value

    Combo138.Value = Combo44.Value

    Text114.Value = Date.Value

    Text116.Value = Text65.Value

    Text118.Value = Text67.Value

    Text120.Value = Text69.Value

    Text122.Value = Text71.Value

    Text124.Value = hr.Value

    Text126.Value = hr1.Value

    Text128.Value = hr2.Value

    Text130.Value = thr.Value

    Text132.Value = text 73.Value

    Text134.Value = Notes.Value

End Sub


This however only copies the information from the last changed or entered recordset. I would want it to show the last viewed, changed or entered recordset in my unbound column.

I think the simple solution to my problem lies in changing
CODE
Private Sub Form_BeforeUpdate(Cancel As Integer)
to something other than beforeUpdate?

Another alternative would be to have two bound recordsets if that is possible and have one be the current that navigation affects and the other one always display the recordset in the first one after navigation (so not necessarily the "previous" recordset in the table if the user for instance jump to a new recordset).

edit: anyway... I don't know how to do either so any help and pointers would be greatly appreciated.

Edited by: JJ1 on Tue Nov 25 17:56:53 EST 2008.
jwhite
Nov 25 2008, 07:22 PM
Welcome to UA! -o!

Are you referring changes that have been previously saved, and then re-displaying the current values along with the before-changed values?

If so, then Audit Trail functionality is what you are looking for:
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.