Run Time Error

[jamphan]

I have the following code linked to an event. when I run this I am getting a run time error that says "Data type mismatch in criteria expression" Any ideas on what could be the problem?

Private Sub Command2_Click()

If IsNull(DLookup("[Acct#]", "qryTest", "[Acct#]=" & Forms![Form]![Account])) = True Then
If IsNull(DLookup("[Acct#]", "qryTest2", "[Acct#]=" & Forms![Form]![Account])) = False Then

DoCmd.OpenQuery "qryTest2", acNormal
Else
MsgBox "The Account Number was not found"
End If
Else
DoCmd.OpenQuery "qryTest", acNormal
End If


End Sub

 

[pbaldy]

The syntax is wrong if acct# is a text field:

http://www.mvps.org/access/general/gen0018.htm

 

[jamphan]

that solved that problem but now I am getting a run time error that says "You cancelled the previous operation" When I debug it goes to the second if statement

 

[jamphan]

that solved that problem but now I am getting a run time error that says "You cancelled the previous operation" When I debug it goes to the second if statement

 

[RV]

Your second IF is redundant.
Remove it.

RV