DLookUp

[Guest]

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.

 

[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] & "")

 

[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?

[quoted text clipped - 3 lines]

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