Control Source

[Guest]

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!!!

 

[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!!!

The query returns just the one value?

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

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