Hello, I have a question about some MS Access issue I am having. My
goal is to make a field that will list any revisions to the data that
have been made and when they were made. I have it mostly working but
the one thing I can't figure out is how to list what the data was
before it was changed. Here is my code so far:

Me.txtRev = Me.txtRev & vbCrLf & Now() & " " &
Screen.PreviousControl.Name & "->" & Screen.PreviousControl

That is in the forms 'BeforeUpdate' event procedure. If anyone knows
how I could also store the value of what the field was before it was
changed, that would help. (I need it to work for ANY field that is
changed)

Thanks for any help you can give me.

~Brian

Use the OldValue property of the text box.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Brian" <Brian.Kibler [at] gmail.com> wrote in message
news:1eed4d7d-9719-40ec-9156-a22bc2a32d90 [at] s12g2000prg.google groups.com...
> Hello, I have a question about some MS Access issue I am having. My
> goal is to make a field that will list any revisions to the data that
> have been made and when they were made. I have it mostly working but
> the one thing I can't figure out is how to list what the data was
> before it was changed. Here is my code so far:
>
> Me.txtRev = Me.txtRev & vbCrLf & Now() & " " &
> Screen.PreviousControl.Name & "->" & Screen.PreviousControl
>
> That is in the forms 'BeforeUpdate' event procedure. If anyone knows
> how I could also store the value of what the field was before it was
> changed, that would help. (I need it to work for ANY field that is
> changed)
>
> Thanks for any help you can give me.
>
> ~Brian