Control Source

W

williamr

I have a query that counts the number of items in a table. On a form I have
a txtbox to display that number. In the Control Source of the txtbox I have
the following code: =qryOffSitesActive!NumberOfOffSitesActive. I get the
#name. What am I missing??

Thanks In Advance!!!
 
F

fredg

I have a query that counts the number of items in a table. On a form I have
a txtbox to display that number. In the Control Source of the txtbox I have
the following code: =qryOffSitesActive!NumberOfOffSitesActive. I get the
#name. What am I missing??

Thanks In Advance!!!
Click to expand...

The query returns just the one value?

=DLookUp("[NumberOfOffSitesActive]","qryOffSitesActive")

Make sure the name of this control is not "NumberOfOffSitesActive"
 
Top