Hi,
I'm new to all this, so sorry if this seems trivial to the experts
I want to compare the choice in a combo box called cboChooseExamPaper with the content of a many-to-many join table called tblPilotGroundExam so that I can trap a repeated selection (so that the same exam can't be attempted twice). My problem is that I don't know how to compare the two. I get a type mismatch error with this: -
If Me.cboChooseExamPaper("[GroundExamID]") = DLookup("[GroundExamID]", "[tblPilotGroundExam]") Then 'If it's a repeat attempt
How do I do this properly without getting the error?
Many thanks for your help!
I'm new to all this, so sorry if this seems trivial to the experts

I want to compare the choice in a combo box called cboChooseExamPaper with the content of a many-to-many join table called tblPilotGroundExam so that I can trap a repeated selection (so that the same exam can't be attempted twice). My problem is that I don't know how to compare the two. I get a type mismatch error with this: -
If Me.cboChooseExamPaper("[GroundExamID]") = DLookup("[GroundExamID]", "[tblPilotGroundExam]") Then 'If it's a repeat attempt
How do I do this properly without getting the error?
Many thanks for your help!