How to run a query if record has been edited

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


"Randy" wrote in message
...
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
--
-Larry-
--

"Randy" wrote in message
...
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