I was not having issues with the DLookUp on the form. The script that I was working fine. It was on the report that I could not get the DLookUp to work.
In anycase,
The form name is called Payroll_Information
Are you opening your report filtered to one record? - No
If so, what code are...
Figured out the text delimiters.
Could you provide an example of how I would use a variable in the filter criteria to replace the current approach?
The WageAmount is number btw.
Thanks
I am trying to do a DLookUp in a report, but I keep getting an error or name issue.
I can get this DLookUp to work in my form (Here is the line in the control source in my form, =DLookUp("[WageAmount]","tblWages","[WageName]=" & "[MEETrt]")
But when attempting to write it in the report I...