record count w/ criteria

[skate]

I am trying to count the number of records in a subform w/ linked fields "Index". The following code works without the "SIndex" criteria, but I want to count the number of records w/ SIndex (of the subform) equalling a certain value. Why does this not work? I've even tried forms![mainfrm].[subform].form!SIndex, but it doesn't work.

= DCount("*", "Job Summary Query", "SIndex =" & SIndex And "Index =" & [Index])

 

[PWise]

try
= DCount("*", "Job Summary Query", "SIndex =" & SIndex & " And Index =" & [Index])