Now "maybe" I understand. Here is how I transfer current
information on a form onto a new form. Create a command
button that will "Add" a new record. Go to the on click
event and paste the following. (This code is assuming
there are only 3 fields on the form and that all 3 fields
will copy to the new form.)
dim tField1
dim tField2
dim tField3
tField1 = txtYourField1
tField2 = txtYourField2
tField3 = txtYourField3
DoCmd.GoToRecord , , acNewRec
txtYourField1 = tField1
txtYourField2 = tField2
txtYourField3 = tField3
This code basically copies the values of your fields into
variables. Then takes those variables and assignes them
into the newly created record.
Let me know if I'm not even close to what you are trying
to do.
-----Original Message-----
Thanks for the reponse, I am including the code that I
am using. Basically the problem is that when the paste
append is invoked, it paste data into a field that has an
event in the afterupdate property. So when the field is
updated, the event kicks an email and another form. What
I would like to do is to disable code from executing
before the append> null out the fields that triggering
the execution> then turn the code execution back on.