By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,482 Members | 2,107 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,482 IT Pros & Developers. It's quick & easy.

Revision Tracking

P: n/a
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
Dec 20 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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
Dec 20 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.