Count Records in Header

[crimedog]

In the past I created an Unbound Text box in the header of my continuous form. Added =Count([TicketID]) and it worked like a charm.


Now I do the same thing and the Text box is blank.

TicketID is the primary ket (autonumber) for my table.
The form is based off a query that includes TicketID. and lists the records...
Everything works great except the Count function that is in the form header.
I have tried =Count([TicketID]) =Count(*) both return blank textbox

I have tried =DCount("[TicketID]","[QueryName]") returns #error
etc...

This is all in the Control Source

What could I possibly be doing wrong? It worked in my last DB - (same version Access 2010)

[Missinglinq]

Try

=DCount("*","QueryName")

in the Control Source.

Linq ;0)>