I'm doing a 'what-if' scenario, so I don't want to change
my original table data. If all recordsets in Access are
linked to tables, I guess there's no choice but to use a
temp table. Thanks, Rosco.


-----Original Message-----
What kind of changes are you making. Can these
modifications be a calculation against fields in your
orginal table?
Rosco

----- Andy wrote: -----

I want to take data from a table, modify it and put
it in
a report without changing the original table data.
OpenTable links the rst to the table data as
does .clone.
OpenSnapshot locks the records for modification. I
ended
up using a temp table, but this isn't very elegant.
How
can I create a modifiable copy of a recordset
independent
of the original?

.