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

Your DCount() is not finding the value you are looking for because of the quotes around strCount.

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

If [mbrid] is a text field then you need to get the quotes imbedded in the contents of strCount.

strCount = "'" & Forms![frmcallhis]![mbrid] & "'"

...or

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

Mike

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

Much appreciation

kim