VBA code to run an append and a delete query

  • Thread starter Thread starter SusanR
  • Start date Start date
S

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.
 
SusanR said:
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.
Click to expand...

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?
 
Back
Top