info from another query into a form

[kwill]

my form is based on one query, but I'm trying to add a text box which is based on a field in another query and all I get is #name?

here's what I've got in the control source:
=queries![Team to Svc Co Query]![Service Co]

Everything is spelled right. I used the expression builder. Also I can run the query fine and it comes up with the right info. Any ideas? thanks

 

[scking]

Look up the DLookup function in help.

Steve King
Growth follows a healthy professional curiosity