DLookUp

K

Klatuu

Yes, you just need to get the syntax right:

=DLookUp("[EmpFirstName]& ' ' & [EmpLastName]","tblEmployees","EmployeeID =
" & [Forms]![frmReportDates]![TxtManID])

Your original code indicates EmployeeID is a numeric field. If so, the code
above should be correct.
 
D

DS

I'm trying to use DLookUp to find a combined field. Can I do this or is
there another way?
Thanks
DS


=DLookUp("[EmpFirstName]&"" " "&[EmpLastName]","tblEmployees","EmployeeID =
" & [Forms]![frmReportDates]![TxtManID] & "")
 
B

bootybox via AccessMonster.com

This worked really real!
Thanks
DS
Yes, you just need to get the syntax right:

=DLookUp("[EmpFirstName]& ' ' & [EmpLastName]","tblEmployees","EmployeeID =
" & [Forms]![frmReportDates]![TxtManID])

Your original code indicates EmployeeID is a numeric field. If so, the code
above should be correct.
I'm trying to use DLookUp to find a combined field. Can I do this or is
there another way?
Click to expand...
[quoted text clipped - 3 lines]
=DLookUp("[EmpFirstName]&"" " "&[EmpLastName]","tblEmployees","EmployeeID =
" & [Forms]![frmReportDates]![TxtManID] & "")
Click to expand...
Click to expand...
 
Top