Too Easy.... query as control source for text box question...

[MikeDNova]

I have a query with 4 fields that I am trying to use as a control source for a text box. I only want to use one
field of the query as the control source. This is the line
of text that I entered as the control source,
"=[qryMBrickChurchillSel]![quantity]"

whats wrong with this?? It does not seem to be working.

Thanks

 

[Terpsfan]

Set the form control source as qryMBrickChurchillSel in the properties windows and then the set the control source for the text box to quantity in the text box properties window.

 

[MikeDNova]

ok, the reason i can't do this is that i have a whole bunch of text boxes that i want to do the same thing with. is this doable?


there are about 16 text boxes at least that I want to use queries as control sources for...

feasible or not??