|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
On frmParentForm_Load, I am doing
"[created_on] >= #" & Me.RecentOrderDateCutoff & "#"
|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
| How to reference parent form from subform when parent name can be different |
| by M0dusFRee in Access|
I want to reference a button on the parent form of a
subform. The parent however could be two different form names.
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
|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
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|
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|
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|
I've managed to use all of these independently before
but when I put them together I seem to be missing something...
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