Gibberish when pulling calculated field from form

[rjasong23]

˜˜I have a query that has a calculated field that looks something like this:

amountdue: [Forms]![invoice]![amountdue]

The [amountdue] field is actually calculated in the open form as a currency amount and is calculated by the following:

=[invoiceamount]-[paymenttotal]

In short, this query is run to generate a report based on the open form. However, when I run the query I get nothing but gibberish for the [amountdue] field. Any ideas why?

 

[RV]

Create a query which includes all the columns you actually show as controls on your form.
Add a calculated column to your query which calculating the amount due.
Save your query.
Base your form on the query and open your form.

Does that still result in "glibberish"?

RV