If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
pass form field to subform?
good day all,
I have the following forms and fields: frminvoices field1 field2 field3 frminvoicedetails subform within frminvoicedetails subform I have frminvsubform What I am trying to do is pass the field1, field2, field3 to the same field names in my frminvsubform within my frminvoicedetails subform. any suggestions? Thanks, Brook |
#2
|
|||
|
|||
On Tue, 16 Aug 2005 11:15:03 -0700, "Brook"
wrote: good day all, I have the following forms and fields: frminvoices field1 field2 field3 frminvoicedetails subform within frminvoicedetails subform I have frminvsubform What I am trying to do is pass the field1, field2, field3 to the same field names in my frminvsubform within my frminvoicedetails subform. If you REALLY REALLY want to do this, set the Master and Child Link Field properties of frmInvoiceDetails to whatever is there now;Field1;Field2;Field3 and the same for frmInvSubform. HOWEVER... I can concieve of *no* proper relational reason to store data from a mainform's Recordsource in a grandchild table! Could you explain what these fields are, and why you feel called upon to store them both in the main form's table and in frmInvSubform? John W. Vinson[MVP] |
#3
|
|||
|
|||
Good day,
Thank you for the information, I set it up and it works, but doens't save the fields passed to frminvsubform to the tblinventory? Any ideas? The reason that I am wanting to store the values, is that each of my inventory items are unique and that not one will ever be the same. Brook Thanks, Brook "John Vinson" wrote: On Tue, 16 Aug 2005 11:15:03 -0700, "Brook" wrote: good day all, I have the following forms and fields: frminvoices field1 field2 field3 frminvoicedetails subform within frminvoicedetails subform I have frminvsubform What I am trying to do is pass the field1, field2, field3 to the same field names in my frminvsubform within my frminvoicedetails subform. If you REALLY REALLY want to do this, set the Master and Child Link Field properties of frmInvoiceDetails to whatever is there now;Field1;Field2;Field3 and the same for frmInvSubform. HOWEVER... I can concieve of *no* proper relational reason to store data from a mainform's Recordsource in a grandchild table! Could you explain what these fields are, and why you feel called upon to store them both in the main form's table and in frmInvSubform? John W. Vinson[MVP] |
#4
|
|||
|
|||
On Wed, 17 Aug 2005 06:57:05 -0700, "Brook"
wrote: Good day, Thank you for the information, I set it up and it works, but doens't save the fields passed to frminvsubform to the tblinventory? Any ideas? The reason that I am wanting to store the values, is that each of my inventory items are unique and that not one will ever be the same. Since I have NO trace of an idea about your table structure, the Recordsources for the forms, or the master/child link fields you're actually using, it's more than a bit difficult to say what might be wrong. And even if all the inventory items are unique, there is still no reason I can see to store information about them redundantly. Please give me a hand here... what are the relevant tables? What fields are you trying to transfer? WHY is it important to store the same three fields of information in two different tables, rather than using a Query to link them to pick up the information? John W. Vinson[MVP] |
#5
|
|||
|
|||
Good Day John,
I was wondering if there was a way to "pass" the data by using a formula such as: =[Forms]![frminvoices]![frminvoicedetailssubform].[Form]![invoicetype] Thanks, Brook "John Vinson" wrote: On Wed, 17 Aug 2005 06:57:05 -0700, "Brook" wrote: Good day, Thank you for the information, I set it up and it works, but doens't save the fields passed to frminvsubform to the tblinventory? Any ideas? The reason that I am wanting to store the values, is that each of my inventory items are unique and that not one will ever be the same. Since I have NO trace of an idea about your table structure, the Recordsources for the forms, or the master/child link fields you're actually using, it's more than a bit difficult to say what might be wrong. And even if all the inventory items are unique, there is still no reason I can see to store information about them redundantly. Please give me a hand here... what are the relevant tables? What fields are you trying to transfer? WHY is it important to store the same three fields of information in two different tables, rather than using a Query to link them to pick up the information? John W. Vinson[MVP] |
#6
|
|||
|
|||
On Wed, 17 Aug 2005 20:47:05 -0700, "Brook"
wrote: Good Day John, I was wondering if there was a way to "pass" the data by using a formula such as: =[Forms]![frminvoices]![frminvoicedetailssubform].[Form]![invoicetype] That will let you *display* the data, but not store it. You'll need VBA code in some suitable event (the Subform's BeforeUpdate perhaps) to "push" the value into a bound control: Me!invoicetype = _ & [Forms]![frminvoices]![frminvoicedetailssubform].[Form]![invoicetype] John W. Vinson[MVP] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Multiple Options Group | Patty Stoddard | Using Forms | 19 | August 4th, 2005 02:30 PM |
pass a calculated form field to a subform field? | Brook | Using Forms | 22 | April 28th, 2005 04:56 PM |
strategy for data entry in multiple tables | LAF | Using Forms | 18 | April 25th, 2005 04:04 AM |
dlookup | miaplacidus | Using Forms | 9 | August 5th, 2004 09:16 PM |
Recordset in subform based on field in parent form | Lyn | General Discussion | 15 | June 14th, 2004 03:10 PM |