Dlookup and No Data

[Vasago]

I have a Dlookup Function that performs perfectly if their is data but when there isn't data I run into the runtime error. What is the best way to work around this so my users aren't getting a error.

[Punch ID] = Nz(DLookup("[Punch ID]", "[Copy of Employee Work Statistics1]", "Employee='" & Forms![Royal time Stamp]![Driver] & "' And [Date]=#" & Date & "#" & " And [Trip Sign Off]=0"), 0)

[Vasago]

Problem solved using error handling

On Error GoTo error_nodata
[Punch ID] = Nz(DLookup("[Punch ID]", "[Copy of Employee Work Statistics1]", "Employee='" & Forms![Royal Time Stamp]![Driver] & "' And [Date]=#" & Date & "#" & " And [Trip Sign Off]=0"), 0)
[Type of Work] = Nz(DLookup("[Type of Work]", "[Copy of Employee Work Statistics1]", "Employee='" & Forms![Royal Time Stamp]![Driver] & "' And [Date]=#" & Date & "#" & " And [Trip Sign Off]=0"), 0)
[Trip_S_on] = Nz(DLookup("[Trip Sign On]", "[Copy of Employee Work Statistics1]", "Employee='" & Forms![Royal Time Stamp]![Driver] & "' And [Date]=#" & Date & "#" & " And [Trip Sign Off]=0"), 0)
error_nodata:
Exit Sub

[Seth Schrock]

What is the error number and description that you get?

[NeoPa]

Neither set of code, as posted, will ever run correctly and without error. Variables in VBA cannot take brackets ([]) and the syntax makes no sense for SQL.

It's hard to help when the question doesn't even make sense. Such a question, even with code that makes sense, would need an error message as a bare minimum.