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:

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)

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:

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)