Does anyone know of a built in function/method that will move an entire record out of one table and into another (the elusive archive query)?
I know I can do it in code but I'm hoping that Microsoft has done it for me.
build an append query based on your two tables, select the fields you want appended and base the criteria on the Forms Controls that are bound to the key fields
Forms!YourFormName.YourControlName
Add a command button to open the query. Then all you have to do is select the correct record and click on the command button.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.