On a continuous form I have a DCount expression as the control source for one of my textbox controls. The expression is thus:
=DCount("DegReqDiscId","DegReqDisc","DegReqId = " & [txtDegReqId])
It works fine except that on the new record row it displays #Error. I know it's doing that because the txtDegReqId is (New) and will be so until a new record is entered. Is there a way that I can get it to show blank (or 0) for the new record row?