Functions

[Guest]

I ahve a report that needs to pull a number off a form. However the number
being pulled is not being recorded it is just a calculation on the form. The
text box calculation is:

=((underlayment.Form![order subtotal])+(membrane.Form![order
subtotal])+(Splice.Form![order subtotal]))

I can not put that in a text box on a report because it does not work....How
is this done?

 

[Allen Browne]

Presumably you have 3 subforms on your main form.

If the main form is named Form1, and that text box is named Text1, and the
form is open, then you could just use this in the Control Source of a text
box on your report:
=[Forms]![Form1]![Text1]

 

[Guest]

If the form still open, create a text box in the report and refer to the
field in the form
=Forms![MainFormName]![FieldName]

If the form is closed, and you run the report through that form and then
close the form, pass the value using the OpenArgs

Dim MyOpenArgs as String
MyOpenArgs = Me.[FieldName]
Docmd.OpenReport "Reportname", , , , , MyOpenArgs

In the section where the field is located in the report, on the OnFormat
event write the code
Me.[FieldName] = Me.OpenArgs
======================
I hope that what you are looking for, if not, can you give some more details