Dcount is always 0

[Blkblts]

I have the code"
strCount = Forms![frmcallhis]![mbrid]
intCount = Dcount("[mbrid]","tblcall","[mbrid] = 'strCount'")
intcount = intcount + 1

intcount is always 0 even if there are several calls for mbrid

I'm just trying to get the count from tblcall based on a mbrid and up by 1.

Thanks

 

[Atomic Shrimp]

...or

intCount = Dcount("[mbrid]","tblcall","[mbrid] = '" & strCount) & "'")

Mike

 

[Blkblts]

Thanks it works.... by the way my mbrid was a string value.

Much appreciation

kim