Form and subform, parent and children in a transaction

I have a parent record and child records. After creating the
parent, there must be at least one child record. On closing the
form I could, in principle, delete the parent and child (or children),
if the user changed his mind. Or, I could presumably wrap this
entire enterprise in a transaction, something along the lines referred
to here: http://www.access-programmers.co.uk/...d.php?t=261029If
you have done something like that would you mind sharing the
code?

I have a parent record and child records. After creating the
parent, there must be at least one child record. On closing the
form I could, in principle, delete the parent and child (or children),
if the user changed his mind. Or, I could presumably wrap this
entire enterprise in a t

I am trying to refer to a subform within a subform from my parent
form how do i do this? Also i want to refer to my parent form from my
subform and the subform within the subform.Any suggestion would
help!!!!

All,I want to reference a button on the parent form of a
subform. The parent however could be two different form names.frmlogfrmcorrectiveHow do I check which form is loaded
in order to create the reference to the correct parent? The parent
will always be loaded at the time t

I added a text box on my main form. I have to other parent
names in a subform that I would like to add to my main form. I have
this working just using one parent name "dtdrec" that is
working. How would I add "flduser" and
"fldstuff".=[tblPayEstimates

Hi,Scenario:Parent form: An order form (Order table)
with data fields like Order ID and etc. In my Order Table, I have a
revenue data field, which is a calculated field based on numbers of
items in its subform (OrderDetails table).Since the profit data
field is based on the i

Ok,I've managed to use all of these independently before
but when I put them together I seem to be missing something...I
have a subform (Invoice) with two fields on that are relevant...txtInvoiceAmount and chkSentI want to be able to on my parent
form have an unbound fie

I have a subform inside a parent form. The subform shows up as a
datasheet inside the parent form. I have two comboboxes in the
parent form. When the user chooses a value from the combobox the
subform should get filtered according to those two values.

GdayI'm building a client database, and have nearly
completed the main data ebtry form. However, I would like to add some
search functionality to this form. The main form shows all the
details of the client, and I have created a subform below this to
conduct Lastname or MemberNumber

I have login form (frmB) placed as a subform on a parent form
(frmA).When a user logs in, the login subform (frmB) opens
another form (frmC).I then want form (frmA) having (frmB) to
close.frmC opens OK, but...DoCmd.Close acForm,
"frmA" does not close frmA.TAGS:subformclosesparentform