Need a fresh set of eyes please (Dcount issue)

[Gina Maylone]

I am simply trying to count the number of records in a subform. I have =DCount("*","mechanicalinquired","referencenumber= " & [RererenceNumber]) and I've tried =DCount("*","mechanicalinquired","referencenumber= [RererenceNumber]") and about 100 other combinations. I get #ERROR# or #Name? in the field. Referencenumber is a number field. The dcount field is an unbound field (Text64), my table name is MechanicalInquired. What am I missing please??

Thank you in advance!

[ranman256]

On the subForm ,put a text box on the footer.
set it to a field, the alter it to =count(field)
then you will have a count.

[Gina Maylone]

On the subForm ,put a text box on the footer.
set it to a field, the alter it to =count(field)
then you will have a count.

Thanks Ranman - but I still get #Error.??? I have triple checked field names, spelling, etc.

[Gina Maylone]

Nevermind...it's working now! UGH! Thank you much!