VBA code to run an append and a delete query

[SusanR]

I have a process that has a print button. What I want to
do is..when the print button is pressed run my query
called appendtohistory, sending it the needed criteria, to
copy that record to a history table and then run my
deletefromcurrent query(sending the same criteria) to
delete that record from my original table. I can't get the
event procedure to work. Any suggestions on the coding
Thanks
Sue.

 

[Dirk Goldgar]

I have a process that has a print button. What I want to
do is..when the print button is pressed run my query
called appendtohistory, sending it the needed criteria, to
copy that record to a history table and then run my
deletefromcurrent query(sending the same criteria) to
delete that record from my original table. I can't get the
event procedure to work. Any suggestions on the coding
Thanks
Sue.

Please post the event procedure you've written. In what way do you
"send the needed criteria" to the appendtohistory query? Is this a
query with parameters?