greensleeves149
Member
- Local time
- Tomorrow, 01:18
- Joined
- Feb 27, 2022
- Messages
- 49
Hi all,
I have a form with a couple of subforms on it. These subforms have a summed total amount which I want to populate an entry in the main forms table. For example, let's say each subform on the main form contained a summed total for Widget A amount (on subform 1), Widget B amount (subform 2) and Widget C amount (subform 3)- let's say $15, $25 and $50 respectively.
If on the table running the main form I have something like "Widget A Total", "Widget B Total", "Widget C Total", how would I get the totals from the subforms to populate the form's main table respective entries with $15, $25 and $50?
I tried something like: Me.WidgetATotal = Me.WidgetAAmount and put that with the "On Change" Event. Tried it, did nothing.
Could anyone please tell me what I'm doing wrong or a better way to go about it?
Thank you.
I have a form with a couple of subforms on it. These subforms have a summed total amount which I want to populate an entry in the main forms table. For example, let's say each subform on the main form contained a summed total for Widget A amount (on subform 1), Widget B amount (subform 2) and Widget C amount (subform 3)- let's say $15, $25 and $50 respectively.
If on the table running the main form I have something like "Widget A Total", "Widget B Total", "Widget C Total", how would I get the totals from the subforms to populate the form's main table respective entries with $15, $25 and $50?
I tried something like: Me.WidgetATotal = Me.WidgetAAmount and put that with the "On Change" Event. Tried it, did nothing.
Could anyone please tell me what I'm doing wrong or a better way to go about it?
Thank you.