T
TK
I have an unbound main form in single form view and a
subform in datasheet view that has an ADO recordset
assigned through code.
For the most part the form is working properly, but when I
try to use a transaction to control recordset updates I am
having difficulty getting variables and objects declared
on the subform to be recognized by the main form, and vice
versa.
I have tried setting the procedures and variables as
Public, and have tried referencing the variables as
properties of the parent or subform, but only with limited
success. What is the proper way to set up the ADO
connection and recordset objects, and how should these be
referenced by parent or child procedures?
The goal is to have a couple buttons on the main form to
commit or roll back the transaction, but the data is all
in the subform...
Any help greatly appreciated.
TIA,
TK
subform in datasheet view that has an ADO recordset
assigned through code.
For the most part the form is working properly, but when I
try to use a transaction to control recordset updates I am
having difficulty getting variables and objects declared
on the subform to be recognized by the main form, and vice
versa.
I have tried setting the procedures and variables as
Public, and have tried referencing the variables as
properties of the parent or subform, but only with limited
success. What is the proper way to set up the ADO
connection and recordset objects, and how should these be
referenced by parent or child procedures?
The goal is to have a couple buttons on the main form to
commit or roll back the transaction, but the data is all
in the subform...
Any help greatly appreciated.
TIA,
TK