Form with a subform - rollback changes

I have a form with a subform and buttons "Ok" and "Cancel". "Ok" button behaviour is obvious. But when the user enters the subform, Access saves the record from the main form. Is there any way to organize rolling back without using temporary tables or arrays ?
shvetsovAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
Advertise Here
 
tomookConnect With a Mentor Commented:
No way with bound forms. Access commits the changes when it saves. If you need to do this, you must use unbound forms or temporary tables.
0
 
brewdogCommented:
I'm assuming these are bound forms. I don't know of any way, other than temporary tables, to do this with bound forms. With unbound forms, you can create a WorkSpace object and do a BeginTrans and then either a CommitTrans or a Rollback at appropriate points.

brewdog
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.