Form and subform, parent and children in a transaction


ozymandius42
HOME ยป Access

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=261029
If you have done something like that would you mind sharing the code?

Related to : Form and subform, parent and children in a transaction
Form and subform, parent and children in a transaction
by ozymandius42 in Access
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
Possible to set filter on subform from parent form before subform data loads
by Italy in Access

I have frmParentForm with multiple controls used to build a filter for frmSubForm.


On frmParentForm_Load, I am doing (simplified example):


Me.sbfInvoice_List.Form.filter = "[created_on] >= #" & Me.RecentOrderDateCutoff & "#"
Me.sbfInvoice_List.Form.Filte
How to refer to a subform within a subform from the parent form
by Alan Xu in Access
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!!!!

How to reference parent form from subform when parent name can be different
by M0dusFRee in Access
All,
I want to reference a button on the parent form of a subform. The parent however could be two different form names.
frmlog
frmcorrective
How 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
add another parent name from a form to a subform
by Allan in Access
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
Filter Subform from Parent Form
by xSauronx in Access

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.


The following is the code


How do i get a value from a control from in a subform to use in my parent form?
by New Jersey in Access
Hello, thanks for all your help up to now.
How do i get a value from a subform to use in the main form?
Heres what im working on:
Attachment 17500
I want access to look at the value in a combobox in the subform, see what it is then if its "blahblah" then do this, i
Getting parent form to respond to subform
by tayles in Access
Gday
I'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
Reflecting Changes on the SubForm to Parent Form
by semicolonth in Access
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
sum iif using subform fields in parent form...
by lync-server-2010 in Access
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 chkSent
I want to be able to on my parent form have an unbound fie
Privacy Policy - Copyrights Notice - Feedback - Report Violation - RSS 2014 © bighow.org All Rights Reserved .