Dlookup question

[GetReel]

Im trying to display the LastName and GivenName in a message box using a dlookup. I have the Message working nicely but becuase there many people with the same surname I need to have the Givenname to included in the message box

strOwner = DLookup("[LastName],[GivenName]", "tblClient", "[SSN]='" & Me.SSN & "'")

I need to have the same concatenated.

 

[pbaldy]

You can't get them both in one dlookup. You need to concatenate 2 dlookups together with the comma:

DLookup("LastName"...) & ", " & DLookup("GivenName"...)

 

[GetReel]

Thanks!

I didnt know i needed to use two dlookups.

I dimmed the results of the dlookup and then cancatenated
(" & strRecordOwner & " , " & strGivenName & ")

works nicely now!


thanks a million