Append and Delete query (1 Viewer)

[TimjHebert]

I have 2 databases which are mirror images of each other. one db is named rent and the other is named renthistory. in the db i have 2 tables, tblcustomer and tblradio. i would like a button on my form to append the current record to the renthistory db and then delete the current record. how can i do this?

Thanks in advance!
Tim

 

[godofhell]

Create your append and delete querie, then in the VBCode write code that runs the queries when the button is clicked. Of course make sure that your query criteria is set to delete the selected record.

Sub mybutton_onClick()
Docmd.Runquery "qryAppendtohistory"
Docmd.Runquery "qryDeleteRecord"
End Sub

 

[TimjHebert]

append and delete

Thanks for the information, but how do i set my code to append the current record?

Thanks in Advance!
Tim