Form and subform, parent and children in a transaction



Category : 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?

View Replies

Related to : Form and subform, parent and children in a transaction


Possible to set filter on subform from parent form before subform data loads
Category : Databases

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

View Replies


How to refer to a subform within a subform from the parent form
Category : 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!!!!

View Replies


How to reference parent form from subform when parent name can be different
Category : Development
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

View Replies


Best way to display data in parent-child form, where one parent can have multiple children
Category : ASP & ASP.net

My first post here was answered so successfully that I thought I'd throw another out there, if anyone has any ideas.

The information is as such: Team X contains Persons Y. Persons Y are responsible for Jobs Z. X is singular, however there may be multiples of Y and Z.

For instance: Tea


View Replies


How to update children on a parent-children form
Category : ASP & ASP.net

Hello All

(First, I am a complete newbie to MVC. I have inherited a MVC project when one of our developers left).

On one page we will have a parent/child presentation and I need to be able to edit multiple children in one pass (or perhaps with some Ajax).

Some details (using a s


View Replies


add another parent name from a form to a subform
Category : 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

View Replies


Getting parent form to respond to subform
Category : 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

View Replies


How do i get a value from a control from in a subform to use in my parent form?
Category : 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

View Replies


sum iif using subform fields in parent form...
Category : 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

View Replies


Reflecting Changes on the SubForm to Parent Form
Category : 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

View Replies


2012 / 2017 Copyrights BigHow , All Rights Reserved .