I'm using this code:
If DCount("[Part_Number]", "Etching_Schedule", "[Part_Number] = 'Me.txtPart_Number'") > 0 Then
MsgBox "That part number already exists for that date and shift."
The code executes without error. That part number does exist and it should go to the message box, but does not.
If I change the > to =, the message box does come up.
I don't understand why it is not finding the matching record.