Form that allows in-form edits but not actually editing underlying data?

[Access9001]

I have a form that generates data based on a recordset. I want a user to be able to change values and then press a Print button. However, I don't want those user changes to be reflected in the underlying data. How can I do this?

 

[HiTechCoach]

I have a form that generates data based on a recordset. I want a user to be able to change values and then press a Print button. However, I don't want those user changes to be reflected in the underlying data. How can I do this?

I would append the data to a temp table. Set the form and report to use this table.

 

[Access9001]

Right now I am using a temporary table as my recordset, but I want this to be something a bit more dynamic. How would I set the recordset's source buttons in the form to something that creates created/deleted on the fly and derived from another recordsource?

 

[HiTechCoach]

I would use a Delete query to clear the data. An Append query to add the data.

Without knowing more about how the form works, I am not sure where to place the code.

For exmample, if you have a pop-up for that display the single record then:

1) open the form passing an open args witht he primary key for the desired record
2) In the On Load event run queries to clear the tmp table and append the desired record using the value passed in the OpenArg
3) requery the form.

or maybe

1) open the form
2) In the On Load event run queries to clear the tmp table and append the desired record using a form reference to get the the primary key for the desired record.
3) requery the form.