Close a RecordSet in a form but still display the last data it contained (access 2003)

I'm working on a bit of Access 2003 VBA code that pulls data from a temporary ta开发者_Python百科ble and shows it in a forms recordset, I then need to delete the temp table but I can't do this until I've disconnected from the Recordset, which removes the data.

What can I call instead of Recordset.Close or RecordSource = "" which would keep the data on the form but close the connection to the table so I can delete it.

Thanks !

Off the top of my head, I think you can create a disconnected recordset by setting the recordset's ActiveConnection property to Nothing after you've gotten the data that you wanted. Google "disconnected recordset" for more info.

Can you Clone the recordset so you have a copy?