calculated control in a form

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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200612/1

Hi Slez,

If the data you want is "on a form", it must be being stored in a table
somewhere. Simply grab the data out of the table directly rather than
attempting to reference a form that may or may not be open, eg:

=dlookup("FIELD1 + FIELD2", "TABLE", "WHERE_CLAUSE")

or maybe dsum, depending on the actual structure of data you are working with.

Hope this helps.

Damian.

"Slez via AccessMonster.com" wrote:

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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200612/1