Basic Count([Field]) returns Error

[crimedog]

I have a Continuous form populated from Query.
In the Form Header I have an unbound text Box. I added =Count([StepID]) Then tried =Count([TxtStepID]) (operator name) There are no blanks and the field is numerical... I should return 5 but it returns Error.
I have successfully used DCount referencing the Query - but it takes too long to populate (because it is a rather complicated set of iifs etc...



BUT I can't even get the simple Count([StepID]) to work

[JoeM]

The Form Header happens BEFORE there is any data (the data starts being populated in the Detail section).
So it makes no sense to put the COUNT function there.
Try putting it in the Footer.

[crimedog]

Originally I had it in the Footer - but got the same issue...

[June7]

Might not seem to make sense but Count(*) or Count([fieldname]) in form header works for me.

If you want to provide db for analysis, follow instructions at bottom of my post.

[crimedog]

CountTest.zip
Think I have it. The form has the Count in the header and the footer - neither work ( renamed the control object Txt..)

[CJ_London]

another way is

=Count([InstallID]>0)

[June7]

Normally a form does data entry/edit for 1 table. Why are you using this complex a query for this form? Especially since only fields from tblInstalls are needed. Just bind form to TblInstalls.

TxtStepID is bound to wrong field. Should be ProjectStepID not StepID. Also TxtRepName should be bound to Rep not RepName. Use comboboxes instead of textboxes to select rep and step.

Make those changes and the Count() works.

Aggregate functions can only reference fields, not controls.

[orange]

This works for me. I removed some of the txtboxes.
Included a png of the Form with data.

[ssanfu]

Appears to be corruption in the original dB. I created a new dB, then imported all objects from "TEST.accdb".
After the import, the main form in the new dB matched the image orange posted.(with the exception of the regional settings.... ie Date format )

[crimedog]

Used June's direction no luck - remade it as SSanfo suggested and used June's direction, it worked.
Wonder if there is a way to un-corrupt the Db

[June7]

Sometimes yes, sometimes no. Corruption can cause a db to be completely non-functional. Sometimes just requires re-creating an object.

But I don't think I encountered corruption. After the edits I described, form worked just fine.