Copying a specific record

[branston]

Ok... I have a form with a button. When that button is pressed I want it to look at the current record the form was on, store certain fields, then open a table find the fields it stored (i.e. the same record) copy it and paste it into a new table. At the moment it just opens the table and copies the 1st record. Any ideas?

 

[jsv2002]

Use an append query to "copy" the fields you want from the source table to your secondary table run the query from your command button with something like:

DoCmd.OpenQuery "qryAppend"

good luck John