Type Mismatch

[essence]

I am getting a type mismatch error on this if statement.

If DCount("*", "tblEvaluation", "[ECycle] = " & Forms![frmSelectMgr]![Text42] And "[EvaluatorMgr] = " & txtRandomMgr) = 1 Then
MsgBox ("This user has already evaluated a manager")
End If

This piece of code is placed on a command button on a subform and is called "subformManager" and the Text42 is a numeric field on the main form "frmSelectMgr".

Please help!

 

[gemma-the-husky]

you need the AND inside quotes

If DCount("*", "tblEvaluation", "[ECycle] = " & Forms![frmSelectMgr]![Text42] & " And [EvaluatorMgr] = " & txtRandomMgr) = 1 Then


note that your code also assumes BOTH variables to be numeric

ie text42 AND txtrandommgr

 

[Mitch_____W]

I am getting a type mismatch error on this if statement.

If DCount("*", "tblEvaluation", "[ECycle] = " & Forms![frmSelectMgr]![Text42] And "[EvaluatorMgr] = " & txtRandomMgr) = 1 Then
MsgBox ("This user has already evaluated a manager")
End If

This piece of code is placed on a command button on a subform and is called "subformManager" and the Text42 is a numeric field on the main form "frmSelectMgr".

Please help!

If DCount("*", "tblEvaluation", "[ECycle] = " & Forms![frmSelectMgr]![Text42] & " And [EvaluatorMgr] = " & txtRandomMgr) = 1 Then
MsgBox ("This user has already evaluated a manager")
End If

 

[essence]

Thank you both.

This works perfect.