Control source for an unbound textbox

[NeilPattison]

I have a form that uses a query as its control source. The problem I have is that on this form I have an unbound textbox that I need to show the result of another query in. I thought I could do this by using =[Query]![QueryName]![Field name] in its control source, but this isn't working.

What is the right way to go about this?

Cheers

 

[PHV]

Have a look at the DLookUp function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[NeilPattison]

Thanks for getting back quickly PH. I tried using

=Dlookup("[Field Name]","[Query Name]")

but it is just bringing up an error. Is this the right kind of format?

 

[NeilPattison]

I've decided to change the way I'm doing this.

What I've done now is display the results of the query in a subform. What I'd like to do now is use the data on the subform in a calculation that takes place in a textbox on the main form. Is this possible and how do I reference it?

 

[PHV]

Have a look here:

http://support.microsoft.com/?kbid=209099

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[NeilPattison]

Thanks PH. I've sorted this now