Finding the Transaction property of a form

[Guest]

Hello,
I want to check if my form supports transactions. Where do i find this
transaction property?

 

[Allen Browne]

Bound forms are wrapped within transactions that are not exposed to you.

In Access 2000 and later, it is possible to:
- open a transaction,
- open a recordset inside the transaction,
- assign this recordset to the Recordset property of your form,
thus wrapping your form inside your own transaction.

Unfortunately, there does not seem to be any way to get a subform inside the
same transaction, because Access reassigns it every time you move record in
the main form.