S
Slez via AccessMonster.com
I'd like to show a sum of specific fields and calculated fields in a control
on a subform.
The subform that I want the totals to show on, frmBid, has a command button
which opens anther form, frmBidItems. That form contains 2 nested subforms:
frmQryBidLineItems & frmBidLineItemsSubform. The records/fields I want to
sum are in frmBidLineItemSubform.
The records in frmBid, which contains the controls, are in contiinuous view.
I have 2 basic questions:
1. How do I reference the desired records?
2. Can the control automatically recalculate when frmBidItems is closed?
Can that total be kept current with frmBidItems closed? (Obviously, I need
to figure out #1 before #2.)
If there are any examples or resources that contain similar expressions, I
would appreciate being steered in that direction.
Thank you!
Slez
on a subform.
The subform that I want the totals to show on, frmBid, has a command button
which opens anther form, frmBidItems. That form contains 2 nested subforms:
frmQryBidLineItems & frmBidLineItemsSubform. The records/fields I want to
sum are in frmBidLineItemSubform.
The records in frmBid, which contains the controls, are in contiinuous view.
I have 2 basic questions:
1. How do I reference the desired records?
2. Can the control automatically recalculate when frmBidItems is closed?
Can that total be kept current with frmBidItems closed? (Obviously, I need
to figure out #1 before #2.)
If there are any examples or resources that contain similar expressions, I
would appreciate being steered in that direction.
Thank you!
Slez