Thanks for your reply, Van. I think I get the picture.
Access is all table driven and a recordset is just a
subset of a table(s). I have a lot to learn. From now on,
temp tables it is !


-----Original Message-----
AFAIK, Recordsets are just different "views" of data in
the Tables so you
cannot modify data in the "views" without modifying data
in the Tables.

Thus, the temp. Table is the correct solution.

--
HTH
Van T. Dinh
MVP (Access)


"Andy" wrote in message
...
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?


.