asked on Error with DLookup
I am getting a #Error using a DLookup on a report..
Here is the control source for the field:
=DLookUp("[LastName]","tbl
How can I change this to the #Error goes away?
Here is the control source for the field:
=DLookUp("[LastName]","tbl
How can I change this to the #Error goes away?
Microsoft Access
Last Comment
Gustav Brock
ASKER
By the way... LastName is text and may be null.
It should read:
Dim lngID As Long
lngID = Nz([Reports]![rptOpenServi
=DLookUp("[LastName]","tbl
Of course, if rptOpenServiceEvents is not open, it will fail.
/gustav
Dim lngID As Long
lngID = Nz([Reports]![rptOpenServi
=DLookUp("[LastName]","tbl
Of course, if rptOpenServiceEvents is not open, it will fail.
/gustav
ASKER
Am getting invalid use of null with this solution.
Here is what I have which is a copy/paste in the onprint event of the detail section of the report...
Here is what I have which is a copy/paste in the onprint event of the detail section of the report...
Dim lngID As Long
lngID = Nz([Reports]![rptOpenServiceEvents]![txtTechnician5], 0) = DLookup("[LastName]", "tblEmployees", "[ID] = " & lngID & "")
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Perfect! Thanks again.
You are welcome!
/gustav
/gustav