By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,578 Members | 855 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,578 IT Pros & Developers. It's quick & easy.

Recreate/Reset Data Behind Form Data

P: n/a
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.

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies

P: n/a
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.

Nov 13 '05 #2

P: n/a
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.

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.