queries on forms

[Jen0dorf]

Hi



I have created a simple query which if I run gives exactly the result I want.

I want it to display in a fild on a form so I added a test box and in the proporties---control source --opened the expression builder and added into the window

[TotalAnnualIncome]![SumOfCost]

I get the error #Name?

Can someone tell me whatnthe error means

thanks

Ian

[JoeM]

Use the Query as the Control Source of your entire Form, and then you will be able to just drag and drop the fields from the Field box, and everything will automatically be linked.

[ranman256]

If this is the formula of a text box, then the txtBox.rowsource must have an equal sign before the field.
=Textboxname.

but what you have is not a formula and not a reference to a field.
=txtBox1 * 3.14
or
[myField]

which do you want, a field, or formula?