I am having difficulties creating a line to determine if a certain record exists within a table. I have a form where a user put in numbers in four different text boxes and those will be stored in the table. And before they are inserted I wish to check if it already exists.
From my understanding the line would start as:
exist = DCount("[Field1] + [Field2] + [Field3] + [Field4]", "tblcatalog", "[Field1] = '" & me.txt1 & "' ....
And this is where I struggled to find the correct way to construct this line. The usual error I get is a data mismatch even though every input is a number. If there is perhaps a better function to use to accomplish the same thing I would be open to this
From my understanding the line would start as:
exist = DCount("[Field1] + [Field2] + [Field3] + [Field4]", "tblcatalog", "[Field1] = '" & me.txt1 & "' ....
And this is where I struggled to find the correct way to construct this line. The usual error I get is a data mismatch even though every input is a number. If there is perhaps a better function to use to accomplish the same thing I would be open to this