dlookup function

A

Andy G

Can I do this? Have multiple fields be returned in a DLookup function?

=DLookUp("[LastName]" & "[FirstName]","Offender","[SSN] = '" & [Forms]![Edit
Offenses]![cmbSSN] & "'")
 
K

Ken Snell [MVP]

You can return an expression from a DLookup, but it all needs to be in the
"field name" argument:

=DLookUp("[LastName] & [FirstName]","Offender","[SSN] = '" & [Forms]![Edit
Offenses]![cmbSSN] & "'")
 
Top