How to run a query if record has been edited

  • Thread starter Thread starter Randy
  • Start date Start date
R

Randy

I have access 2000, how do I run a query from my form only when a record has
been changed, edited etc. Example: I go to a record from my form, lets say
a week later. I make a change to the record. What I need is to run an
append query only when a change is made. How can i do this. Thanks...Randy
 
Use the before update evnet and/or test for the form being dirty (changed).

Look in the help files for me.dirty


Rick B


I have access 2000, how do I run a query from my form only when a record has
been changed, edited etc. Example: I go to a record from my form, lets say
a week later. I make a change to the record. What I need is to run an
append query only when a change is made. How can i do this. Thanks...Randy
 
Hi Randy,

The implication of your question is that you want to have two versions of
your record. The first version is as it was last saved and the new version
is the one as you just changed. If you really just want to change the
record, just make your changes and move on. The record will be saved as you
have just edited it.

HTH
 
Back
Top