show count query results on form

Harley

Registered User.
Local time
Today, 09:37
Joined
Dec 8, 2005
Messages
54
I have a form that I am trying to show in a text box the results of a count query. The query has two fields in which one is a check box. The criteria for the text box field is set to true to list all that are checked. I want the query to show all the records that are true. This works if I run the query, but the result isn't showing in my text box on the form. On the form text box properties in Control source I have =DLookUp("[Run Number]","Control Room Drumctqry"). Run Number is the field that I am counting, Control Room Drumctqry is the query. Any idea as to what I am doing wrong?
Thanks,
 
Place a text box in your Form's footer. Set it's Control Source to =Count([Run Number])

Hope this helps
 

Users who are viewing this thread

Back
Top Bottom