Results of calculated field do not appear in report

[Jaycee]

I have three fields in a form that calculate intervals
between various dates. The calculation is achieved via
code rather than formula. The results appear correctly in
the form, but appear as 0 in the report. What changes do I
need to make to the report to get the calculated results
to appear?

Thanks!

Jaycee

 

[Fredg]

Jaycee,
A control in a form that uses an expression as it's control source is not
bound to any field in the underlying table.

A solution to your problem will depend on what you're doing in the report.

You can include an unbound control in the report.
Set it's control source to:

=forms!FormName!ControlName

As long as the form remains open, the result on the form will appear in the
report.

A better alternative might be to just repeat the calculation in the report.

 

[Jaycee]

Fred,

How would I include the calculation in the report when
it's several lines of VB code? Thanks!

Jaycee