UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Simultaneously show previous along with current record in the sa    
 
   
JJ1
post Nov 25 2008, 05:54 PM
Post #1

New Member
Posts: 3
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.
Go to the top of the page
 
+
jwhite
post Nov 25 2008, 07:22 PM
Post #2

UtterAccess VIP
Posts: 4,622
From: North Carolina, USA
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:
Go to the top of the page
 
+
« Next Oldest · Access Forms · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 23rd May 2013 - 05:50 PM