How to present calculated field from query in form?

[Runes]

Hi
When I try to present a calculated field from a Query in a form I get "#name" in cell. What I have done in the textbox in form to call up the query and calculated field is in the control source I wrote =[QLinjetotal]![Linjetotal].
Could someone please help me with this issue?

 

[jdraw]

What is the row source (DATA) for the Form?

 

[Runes]

Hi
When I tried the same with a combobox instead of textbox I get what i want.
Thanks!

 

[Runes]

Combobox is not what I want, could someone please tell me what to do when I use a text box?

 

[jdraw]

Well, it would help greatly if you could describe exactly what you have and what you want to accomplish.

If you make your query the record source for the Form, you can use the Form Wizard and display your calculated field automatically.

You could even add a new text box and make its ControlSource the name of the calculated field in your query.

What is the record source of your form?

I have attached a jpg showing
-a query called qMyCalc that has a calculated field called MyCalc
-a Wizard created form based on the query qMyCalc
-a separate textbox text3 showing the ControlSource

I hope this is helpful.