Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Moving an entire record from one table to another.

Status
Not open for further replies.

CautionMP

Programmer
Dec 11, 2001
1,516
US
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.

PaulF
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top