Working with Tables

Close Window 

Using Paste Append

Here’s a trick you can use to create a new record out of an existing one. First, select the existing record and copy the data to the Clipboard (select Copy from the Edit menu, click the Copy button on the toolbar, or press Ctrl+C to do this). Then just select Paste Append from the Edit menu. Access pastes the data as a new record at the bottom of the table.

(Posted 07/29/2001)

Tip-within-a-tip:

“Can you use Paste Append to copy records from one table to another? Try it and see.”