Report containing dynamically generated numbers

[benjee]

Hello,

I am trying to produce a report displaying a breakdown of details from my subform 'fsubEstimates'.

Basically my sub form calculates values from combo/text boxes and stores them in a sub total (that is subject to change).

Now i have been reliably informed that you cannot store a dynamically changing value, so i have been experimenting with mirroring the sub total value into a new text box using the DSum function i.e.

Private Sub EstimateJobValue_Enter()
Forms![frmJobSheet]![EstimateJobValue] = DSum("Forms![fsubEstimates]![SubTotal]", "tblEstimate", "[JobNo]=Forms![frmJobSheet]![JobNo]")
End Sub

By doing this i hope to reference the 'new' text field in the report rather than the 'dynamic' sub total field.

However, im getting errors. I think i'm not refernencing the fsubEstimates properly.

Am i doing this the right way???

 

[Rich]

A report can also calculate values