Calling Value from FORM to Query or Report

[Riaz]

Hi

I created a Main form and 2 sub forms in it. Main form is for the Contract details with initial contract amount.
1st sub form for the Variation amount to the contract
2nd sub form for the progress payment for each contract.


I made calculation inside the Main form for Total contract amount by adding all the Variation amounts
and another calculation for Total paid and balance amount by adding all the progress payment.
Now my question is "How to retrieve those "Total contract amount", " Total Paid" and "Total balance" to either query or report

[alansidman]

Now my question is "How to retrieve those "Total contract amount", " Total Paid" and "Total balance" to either query or report

Are these controls bound to a table with representative fields? If so, you can use the table as the record source for your query.

[Riaz]

No its not bound to a table, its a independent calculation which i made in form

[Riaz]

[Riaz]

Screen shots attached. please refer

[alansidman]

Instead of having unbound controls, why not create queries using the underlying tables of the forms/subforms and then use that information as a subform in your form. In this manner, you already have the information you desire in a query that can become the record source for your reports.

[ssanfu]

A variation of Allan's suggestion would be to use query for the main table and a couple of UDF's to get the Variation amount and the Payment amount, the do the calculation in the query (or in the text boxes in the report).

[Micron]

Wouldn't a version of SELECT [forms]![form1].[text2] AS [Total contract amount] work for each field?