To move them to another table, you need to execute 2 action queries:
- an INSERT to add them to the other table, and
- a DELETE to remove them from the current table.

To get an all-or-nothing result, you will want to wrap these 2 operations in
a transaction. Details in:
Archive: Move records to another table
at:
http://allenbrowne.com/ser-37.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/11550-move-records.html
Reply to group, rather than allenbrowne at mvps dot org.

"pjy" wrote in message
news:99CB3784-C9BC-439C-8706-023A3D7F6977@microsoft.com...
>I wonder if anyone can help...I have a form which displays records of
> services to a specific user. occasionally 1 or more of these
> services\records
> needs to be removed..is there any way I can move these records to another
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11550
> table as I need to then print the records I have removed. I would need to
> use
> the form to display and remove the records via a button if that's
> possible..thanks for your help...
>
> pat