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
|
|||
|
|||
Updating a field in a Table with a subform field
Hi,
I have a form that has a subform. I would like to update the Table that is bound to my form with the info from the subform once the use is done entering the info on the main form. Ex. I want the stockcode field in the subform to update in the stockcode field in the main form's table. Thank You Linda |
#2
|
|||
|
|||
Updating a field in a Table with a subform field
On Thu, 26 Nov 2009 09:33:03 -0800, linda
wrote: Hi, I have a form that has a subform. I would like to update the Table that is bound to my form with the info from the subform once the use is done entering the info on the main form. Ex. I want the stockcode field in the subform to update in the stockcode field in the main form's table. Thank You Linda Could you explain WHY? It appears that either you're storing the stockcode redundantly in two tables, or you're (for some reason) entering a stockcode on the subform with the expectation that it will update the main table. Could you explain your tables structure and relationships, and the recordsources of the main and subform? -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|