DLookUp gets me every time

[atrium]

I want to check the AppStart table for a match on ApplicationId and one of the fields = 'Complete' This is what I have

If (DLookup("ApplicationId", "AppStart", "[ApplicationId] = " & _
Me.ApplicationIdFld & " AND [StartStatus] = '" & "Complete" & "'") = True) _
Then
Me.StartTickFld.Visible = True
End If

I know that there is a row that matches my request but It never goes down the true path
Any Help would be appreciated

 

[MajP]

The logic does not seem to make sense. You are returning an application ID and comparing it to True?

Should it be?

NZ(DLookup("StartStatus", "AppStart", "[ApplicationId] = " & Me.ApplicationIdFld )) = "Complete" Then

 

[atrium]

Thanks MajP for the super quick turn around. I never thought of using it like that.
Thanks heaps.

 

[MajP]

One suggestion for doing Dlookup with a criteria. Save the criteria as a variable so that you can debug it, especially if complex

dim strWhere as string
strWhere = "[ApplicationId] = " & Me.ApplicationIdFld & " AND [StartStatus] = 'Complete'"
debug.print strWhere
'does it look correct? If so try dlookup
...DLookup("ApplicationId", "AppStart",strWhere)

 

[atrium]

Works well mate, thanks heaps