How to dlookup in two fields to get needed info 1

[netrusher]

The first piece of code below works find and is triggered
from a checkbox.

The second piece of code differs in that in order to find
the login name it has to look in two Fields from the
table *1* FirstName and *2* LastName.

I am stumped on how to make the code do this. My example,
2nd piece of code is wrong and I have not been able to
correct this. Does anyone have any suggestions. I need
to lookup both FirstName and Lastname in order to come up
with a LoginName. Thanks for any help.

DLookup("LoginName", "ChangeFormUserNameTbl", "ActualName='" & Me.FirstName & "'" & Me.LastName & "'") & "@nmhg.com"

DLookup("LoginName", "EmailNameTbl", "FirstName='" , "LastName='", & Me.FirstName & "'" & Me.LastName & "'") & "@nmhg.com"

 

[netrusher]

Please ignore my last post. I have other issues before
I need the dlookup.

 

[PHV]

DLookup("LoginName", "EmailNameTbl", "FirstName='" & Me.FirstName & "' AND LastName='" & Me.LastName & "'") & "@nmhg.com"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[netrusher]

Thanks PHV