Subforms and transactions

  • Thread starter Thread starter Sergey Bogdanov
  • Start date Start date
S

Sergey Bogdanov

Hello,

I have a form where I've created own Recordset and attach it to this form
and "BeginTrans". Everything worked fine till I didn't add Subform to this
form. I can't start BeginTrans for this subform. :(
is it possible to start transaction for subform and for main form in the
same time?

And there is another question -- is it possible to pass Recordset to an
newly opened form and after some modification commit transaction.

Thnx in advance,
Sergey
 
Are you trying to create a transaction around a bound form and its subform,
so you can roll back all changes to both? If so, no, I don't believe it is
possible to do that.

I'd love for you to prove me wrong, but I have not been able to achieve
that, and neither have I found anyone who has. The less-than-optimal
workaround is to use a temp table for the edits/deletes/inserts, and only
commit them to the real table later.
 
Back
Top