Recreate/Reset Data Behind Form Data

[chfran]

I have a form that has data behind it. The user can manipulate the
data behind the form through the form and see how it affects the
statistics of the data. The users want to be able to reset or 'start
over' after they have done a variety of things to the data.

How do I do that without closing the form?

I've tried everything I can think of: requery, refresh, etc. I've
tried other things but the only error I get is that the table behind
the form is open or being used by another form (the form I'm on.)

What can I do?

Thanks in advance.

[pietlinden]

you mean the from is bound to a table?

What kinds of changes are you talking about? If they're modifying
data, then it gets saved to the table immediately as soon as you either
go to another record or close the form. Sounds like you want SQL
Server functionality where you can rollback changes at table level,
which you can't do in Access. You could populate a temp table, let
them modify that, and then dump it, but that's about all I can think of.

[chfran]

The form is bound to the table. The table bound to the form is a temp
table. So, I want to be able to recreate the table to its original
state (before any changes were done) from my main table.

Yeah, I want a rollback function like SQL Server has but within the
scope of this temp table and my main table.

So, when the user makes the changes and want to 'start over' the user
hits a button the form (bound to the temp table) and it requeries the
main table based on the original parameters and present the data in its
original form. They have started over...

Thanks for your input. Talking (typing) it over helps me think through
it in my head.