Tranferring Count to Form

[landerson]

Hi. I have created a query that does a simple count of all the unique client records in the database. I would like to display the count on the main form.

How would I go about doing this? Thanks for any help that can be provided.

 

[statsman]

Insert a new textbox on your form
In the control source property enter
Count([fieldname])
Although it would be much easier if you did your count in a query and posted that on the form.

Its not a good idea to put calculated fields on a form. The correct place to do calculations is in a query. If you must do it, change the text box properties to:
Enabled - No
Locked - Yes

This will keep people from trying to make changes to the calculation.

 

[landerson]

Hi, thanks for your help.

I have decided to do the count in a query and display it on the form. But I keep getting the #Name? error.

I think my syntax is wrong. I have put [TotalClientCount]![TotalCount] in the Control Source box. TotalClientCount is the name of the query and TotalCount is the name of the field.

Thanks again.