DLookUp

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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] & "")
 
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...
 
Back
Top