Control source for an unbound textbox

[Neil_Pattison]

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

 

[RuralGuy]

You will probably need to use DLookup().

 

[Neil_Pattison]

I've decided to put this unbound textbox on as a subform. What I'd like to be able to reference the text box on the sub form as part of a calculation in the control source of an unbound textbox on the main form. is this possible?

 

[RuralGuy]

Here is an excellent reference to bookmark. Your particular reference to the subform will be Me!SubformControlName.Form!ControlName. SubForms are displayed on forms by means of a SubFormControl. This control has a name of its own that defaults to the name of the SubForm it is displaying but need not be the same and can be changed independantly from the SubForm.

 

[Neil_Pattison]

Thanks RuralGuy I've done it now

 

[RuralGuy]

Great! Thanks for posting back with your success.