#Name? in Text Field

[londonkiwi]

I am trying to use expression builder in Access2000 to provide a value in a text box. The control source of the text box {ExpectedTCost) is:

=IIf(IsNull([Projects]![TenderPrice]),[NCSdata]![Budget],[Projects]![TenderPrice])

in other words - if there is no TenderPrice value provided, then default to the Budget value.

All I end up with is the value #Name? in text box ExpectedTC. Why?

cheers

 

[Falcon99]

Preface the controls reference with "forms."

ie:
forms.[NCSdata]![Budget]

 

[Clifty]

Assuming that your text box is in a form then your expression needs to refer to other controls on the form and not to to tables. If you have to refere back to tables use dlookup

 

[londonkiwi]

cheers.

Text box is in form.
Suggestions have both help in solving problem.