Access 2010 copy & paste?

Worksheets originally designed in Access in Office 2000. I used to be able just to filter and select the records I wanted then copy and paste them over to another worksheet where I could delete unwanted details and merge with a mail merge letter. With Access 2010 I can filter and copy the records and supposedly get them on the clipboard but cant seem to get both worksheets showing at the same time and Access 2010 wants to close the first sheet down before opening the second thereby cancelling out the copied records...I'm sure I'm just being ultra stoopid but I'm tearing my hair out here.