Missing Operator

[DS]

I'm getting a Missing Operator message on this statement.
Any Input is appreciated.
Thanks
DS

CARDS = Nz(DCount("PayAppliedID", "tblPayApplied", "(PayAppliedCCRef Is Not
Null) And PayAppliedCheckID = " & frm!TxtCheckID.value & " And
PayAppliedRefundID = 0"), 0)

 

[Douglas J. Steele]

What are the data types of PayAppliedCheckID and PayAppliedRefundID. If
either are text, you need quotes around the values.

 

[John W. Vinson]

I'm getting a Missing Operator message on this statement.
Any Input is appreciated.
Thanks
DS

CARDS = Nz(DCount("PayAppliedID", "tblPayApplied", "(PayAppliedCCRef Is Not
Null) And PayAppliedCheckID = " & frm!TxtCheckID.value & " And
PayAppliedRefundID = 0"), 0)

If txtCheckID is NULL you will get this error message. You may need to check
for that situation before this line, or use the NZ() function to return a
value.

 

[DS]

Thanks John. You right the CheckID was null, the value wasn't being passed.
I corrected that and it works now.
Thank you.
DS