DCount with two separate fields in the same table

[TamworthBob]

I have a form (frmCRMEditRF)with a textbox (txtActionNumber) and a subform (CRMPartsRF) with a combo box (cboPartNumber).
I need to check the records in tblRepReport table to check if a record has already been saved by looking to see if there is a record with the contents of txtActionNumber (saved RPIdentifier inthe table)and cboPartNumber (saved in ProductID) that match those in the open form (frmCRMEditRF)
txtActionNumber has input similar to text + date eg computer020520, making it a text field. cboPartNumber records an autonumber eg1426
I have tried dozen of code examples without success
MY CODE"
Dim CHKID As String
Dim CHKProdID As Long
Dim Tot As Double



CHKID = Me!txtActionNumber
CHKProdID = Me!frmCRMPartsRF!cboPartNumber

'Tot = DCount("[RepReportID]", "tblRepReport", "[ProductID] = CHKProdID" And "[RPIdentifier] = '" & CHKID & "'")


If Tot > 0 Then
MsgBox "This record already exists", vbOKOnly + vbExclamation, "Duplicate Record"
End If
Thanks in advance
Bob

[ranman256]

count with asterisk field,
the form fields must be outside of the quotes to resolve, (you dont need the ME, but it shows better to show form objects)
numeric fields dont get delimiters, strings get single quote, dates get #. (here ProdID is numeric, ChkID is string, correct?)

= DCount("*", "tblRepReport", "[ProductID] = " & me.CHKProdID & " And [RPIdentifier] = '" & me.CHKID & "'")

[Bob Fitz]

Can you confirm the following:

1) ProductID is a numeric field in tblRepReport

2) RPIdentifier is a text field in tblRepReport

3) You haven't made any spelling mistakes in DCount()

Where are you using this code.

I have tried dozen of code examples without success

What does that mean? Code doesn't run. Throws errors