DLookup for 2 fields

[kgerlitz]

I have this code that does what I want it to do. However, I want to take it a step further and have it search within the "AFLastName" field for a match as well. How can I modify this code to search both the "AMLastName" and "AFLastName" fields?

Private Sub AMLastName_Exit(Cancel As Integer)
If DLookup("AMLastName", "DatabaseAdoptiveParent", "AMLastName='" & AMLastName.Value & "'") = Me.AMLastName.Value Then
Duplicate.RowSource = "SELECT APIDName FROM DatabaseAdoptiveParent WHERE AMLastName='" & Me!AMLastName & "'"
End If
End Sub

 

[ZmrAbdulla]

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

________________________________________________________
Zameer Abdulla
Help to find Missing people
There’s a world of difference between editorials and advertorials

 

[PHV]

Something like this ?
If DLookup("AMLastName", "DatabaseAdoptiveParent", "AMLastName='" & AMLastName.Value _
& "' AND AFLastName='" & AFLastName.Value & "'") = Me.AMLastName.Value Then

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886