VBA code to run an append and a delete query

message from SusanR on 5 May 2004
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 replied to SusanR on 5 May 2004
"SusanR" <anonymous@discussions.microsoft.com> wrote in message
news:0d5301c432ca$f14dd910$3a01280a@phx.gbl

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?
 

Archived message: VBA code to run an append and a delete query (MS Access Forms)