I built the following code with DLookup but runs into Run-time 2465 Microsoft Access can't find the field '|1' referred to in your expression.
vTPCode = DLookup("[TPCode]", "tblTWTTP", "[TRef]=" & iID & " AND [TPCode]=" & iTPCode & " AND Date() BETWEEN #" & [ApptStart] & "# AND #" & [ApptEnd] & "#")
Note: tbllTWTTP has fields of TPCode, ApptStart, ApptEnd.
I would be appreciated if you could suggest.
Thank you.
vTPCode = DLookup("[TPCode]", "tblTWTTP", "[TRef]=" & iID & " AND [TPCode]=" & iTPCode & " AND Date() BETWEEN #" & [ApptStart] & "# AND #" & [ApptEnd] & "#")
Note: tbllTWTTP has fields of TPCode, ApptStart, ApptEnd.
I would be appreciated if you could suggest.
Thank you.