Can I fetch in a report a calculated field from a form ?

[Leo_Polla_Psemata]

Hi
I have a form which works good enough.
In this form, there is a text box that counts and calculates
records from a subform. The name of this text box is "text1"

Can I fetch this "text1" field in a report ?

 

[pbaldy]

Sure; try a textbox with a control source of:

=Forms!FormName.Text1

replacing "FormName" with the actual name of the form.

 

[Leo_Polla_Psemata]

Hi pbaldy

I tried like your suggestion but it returns error
I tried like this
=[Forms]![BL FORM]![agency fees]
and like this
=[Forms]![BL FORM].[agency fees]

Unfortunately the form name and the field name it two different words with a space.
When I firstly started developing this one, i open the forms and names without little more concern and now it is too difficult to replace names

 

[Frothingslosh]

Is it more difficult than not being able to get your data?

 

[pbaldy]

Is it a subform? If so, the syntax changes:

http://access.mvps.org/access/forms/frm0031.htm

 

[Leo_Polla_Psemata]

Please attached picture
The field is in the form, it calculate records from subform and return a result.

This result is that I want to move in a report (or query and then is report)

 

[pbaldy]

I should have mentioned that the form has to be open when the report runs; is it?

 

[Leo_Polla_Psemata]

No, the form is not open.
It cannot be open.
This is a form with subform , default view "Single Form" , there are 2530 records.
Each record has this calculated field which calculates data from the subform and i need to display in a report or query and therefore go ahead.

 

[pbaldy]

Like I said, to use this method the form must be open; it could be hidden. If it can't be open, you'll need to get the value some other way, perhaps a DSum().

 

[Leo_Polla_Psemata]

Thanks pbaldy

I've tried another method, i made a union select all query.
Data was just perfect in there for an update query however
I've got the following error

Operation must use an updatable query. (Error 3073)

It looks like union selects are not suitable to feed an update query.

Thanks anyway for your comments,
You helped me to stop looking for solutions in areas that are not suitable.

 

[Simon_MT]

I would flatten the Information in the SubForm into a separate Query via totalling and in your Report using a Query add this additional Query and you have the information onto your report.

If you think about the Forms Value is the value on the Form that relates to the Current Record ONLY and does not reflect the underlying calculations or any of the other records on the Form.

Simon