Problem using dlookup

Question

I would like the code below to run something of it returns true and do nothing if it returns false. When I run the code I get a run time error 2471 the expression you entered as a query parameter produced this error 'Pat'. Pat is the value of the TempVar.

If Not IsNull(DLookup("FName", "dbo_Customer", "FName =" & TempVars!FirstName & "")) Then

         MsgBox "Test"

else

         Do Nothing

End If

Answer 1

Thank you for the speedy reply.

I will combine this with a couple of other fields to capture any duplicate inputs.

I usually use DCount() to check for duplicates. For example:

If DCount("*", "dbo_Customer", "FName = '" & TempVars!FirstName & "'") > 0 Then

    'duplicate

Else

    'not duplicate

End If

Hope that helps...

Answer 2

Thank you for the speedy reply.

I will combine this with a couple of other fields to capture any duplicate inputs.

Answer 3

Try

If Not IsNull(DLookup("FName", "dbo_Customer", "FName ='" & TempVars!FirstName & "'")) Then

Answer 4

You're doing a textual criteria search, so you need to surround your criteria in quotes.

DLookup("FName", "dbo_Customer", "FName = '" & TempVars!FirstName & "'")

I also don't understand the DLookUp. Your looking up the FName by searching for the FName?