show count query results on form

[Harley]

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,

 

[MartijnR]

Is that the only thing on that form? If so, why not set the control source of the form to the query and set the textbox using the pulldownbutton in properties

Or maybe I'm misunderstanding you?

 

[Harley]

I added the text box to a pre-existing form. The form is based on a table. I want the result of the count query to show in the text box on the form after the criteria for the count query is entered on the form. The result is later used on a report. Thanks.

 

[Rickster57]

count

Pace a text box in the footer of your form. Set the Control Source to= Count([Run Number])

 

[MartijnR]

ah ok

why not place the textbox in a subform?

 

[Harley]

I will try that.

 

[Harley]

I will try that too!

 

[Harley]

Thanks for everyones help! I finally figured it stumbled across it, Yahoo!!! The count query renames "Run Number" field name to "CountofRun Number"! I had no idea that could happen. That is why the Control Source wasn't found. What brought it to my attention is when I was going to take MartijnR's suggestion to make a subform. I used the wizard and saw that the field name had been changed. Thanks again!!!