IF statement using Dcount

Question

Access complains "Data Type Mismatch in criteria expression" with this code ...

If DCount("[Serial Number]", "INVENTORY OVERVIEW", "[Serial Number] =" & Val(txtSERIAL)) > 1 Then

Serial Number is the field I'm trying to count. INVENTORY OVERVIEW is the table where I am trying to do the count. txtSerial is the text box on a userform.

The objective of this if statement is to determine if there are more than one of the same serial number, and report to the user when they submit a new entry if that serial number already exists within the recordset.

OHHH THE ERROR IM GETTING IS.... Data Type Mismatch in criteria expression — Adam Bowsey, Feb 21 '15 at 19:47
OH SORRY AGAIN, I'm a first time poster, I'm using Microsoft Access — Adam Bowsey, Feb 21 '15 at 19:53

score -1 · Answer 1 · answered Jul 16 '18 at 15:21

-1

you have to add the quotes to the txt object. So: "[Serial Number] ='" & Val(txtSERIAL) & "'")) > 1

answered Jul 16 '18 at 15:21

Mark Leo

1

IF statement using Dcount

1 Answers1