We have a module that reads records from 1 table and adds them to others. The data type on a field changed from numeric to text and we now get a data type mismatch error. I've confirmed all the tables are defined correctly. There must be an issue with the syntax of the code. The If statement below is where it fails
Do Until .EOF
Set rstApplicant = db.OpenRecordset("Charity Applicant", dbOpenDynaset)
If DCount("*", "Charity Applicant", "[MRN] = " & ![MRN]) = 0 Then...
I appreciate your help!