Revision Tracking

[Brian]

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

[Allen Browne]

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" <Br**********@gmail.comwrote in message
news:1e**********************************@s12g2000 prg.googlegroups.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