Control Source from Query

[WillJ]

Hi Guys,

I'm getting a Name(hash) error when I try to set up a control source to a calculted query.
I'd like to just be able to create a form and the write in the control source as it look neater (and it the right way to do it) then subforming a query for one text box.
I presently have tried in the expression build =[qryCallRunningAverage]![Average]
but it's naming and shaming.

Any help would be greatly apprecito!

Best,
WEJ

 

[pbaldy]

You can't refer to a query that way. You can use a DLookup().