I am receiving this error in regards to DLookup: Syntax error (missing operator) in query expression 'Course Number = 'FMF 1002"
This is line of code where error is happening:
CompetencyType = Nz(DLookup("Competency", TableContainUpdates, "[Course Number] = '" & rs.Fields(FieldtoPair) &...