Runtime error 13 on DLookup (1 Viewer)

[lightray]

Hi, after resourcing my Runtime 3075, I've now backed into this one.
I'm trying to check a condition that a user has a previous certificate type and then pop the User to show the condition. Print is a yes/no field, ID fields are numeric. Have I got this right? Appreciate any help it's almost 2am here..

    stDocName = "frmTrainee"
    stLinkCriteria = "[TraineeID]=" & Me![TraineeID]
    
    If CertTypeID = 2 Then
        Answer = DLookup("[CertTypeID]", "[tblCertificate]", "[TraineeID]= " & Me.TraineeID _
        & " And [CertTypeID] = 1" _
        And [Print] = -1)
            If Not IsNull(Answer) Then
            MsgBox "Standard Certificate exists.", vbOKOnly, "Standard"
            DoCmd.OpenForm stDocName, , , stLinkCriteria
            End If
    End If

 

[RuralGuy]

You left out some quotes:

Answer = DLookup("[CertTypeID]", "[tblCertificate]", "[TraineeID]= " & Me.TraineeID _
        & " And [CertTypeID] = 1" _
        [b][COLOR="Red"] & " [/COLOR]And [Print] = -1[COLOR="Red"] "[/COLOR])[/b]

 

[lightray]

Hey RuralGuy, as usual that is awesome spotting.. many thanks. It worked amazingly well. I looked at so many examples on the site, I just couldn't spot it. Probably the 2 am thing..

 

[RuralGuy]

Another pair of eyes is sometimes helpful.