Copy record to another table

[bxbxbx]

Hi,

I'm new to Access, but what I'm trying to do is copy a record from one table to another table and then delete the original record. I want to be able to do this using a button or something within a form. Is this possible?

Thanks

 

[PHV]

Take a look at Append query (INSERT INTO ... SELECT ...) and at Delete query (DELETE FROM ... WHERE ...).
You may consider the DoCmd.RunSQL method for such action queries.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[bxbxbx]

Thanks for you help PHV, I'll take a look at it. Will it allow me to move just the current record that I'm looking at in the form?

Thanks