Finding a record in a recordset

[Guest]

How do I copy some of the fields in MyTable to MyNewTable where
MyTable.RecordID = MyForm.RecordID. The field names are common to both tables
and there are lots of them. Is there a spiffy way to do this without making
each MyNewTableField = MyTableField? Something like, for each field in
MyTable, stick it in the correspondingly named field in MyNewTable. Any help
would be greatly appreciated.

 

[Allen Browne]

If the fields are identical (same data types, in the same order), you can
use the wildcard.

1. Create a query using MyTable.

2. Drag the * from the table into the grid.

3. Change it to an Append query (Append on Query menu.)
Access asks what table to append to.

4. Drag RecordID into the grid.
Clear the RecordID from the Append row.
In the criteria row, enter the limiting value if you want to restrict the
query.

5. Run the query.