add control to a subform - Sum of records

[Kevin]

I have created a multi tab subform in a database being used to generate bids.
One tab contains "general" data about the bid. It's record source is the
Bid table. I would like to add a control to the subform which gives current
sum of records of a calculated field from a query called qryEstimateDetail.
What kind of expression would accomplish this? Do I have to also add a
command button to rerun the query, or can I incorporate this in an event?

Any suggestions are appreciated!

 

[Michel Walsh]

Hi,


Add the control in the main form, below the subform.

You can bind that control to an expression with =DSum( ... , ...,
criteria )

where the criteria will be appropriately supplied.


Hoping it may help,
Vanderghast, Access MVP