Error "You Cancelled the previous operation"

[Carl]

WHen running a DLOOKUP function in a module I get the above error. I cannot
see where I've mis-coded anything and can't see anything different in this
code than in other code where the function works properly.

I am trying to retrieve the "Rate" from "tblPayRate" based on the "Crew"
field in "rstPay". My code is:

curInRate = DLookup("Rate", "tblPayRate", "Crew = " & [InCrew])

What might cause this error message?

Thanks

 

[Ken Snell [MVP]]

The error that you get is common when the DLookup (same for other domain
functions) contains invalid syntax in the expression or contains reference
to a field that does not exist in the table.

Is Crew a text field in tblPayRate table? Assuming that it is, delimit the
InCrew value with ' characters:
curInRate = DLookup("Rate", "tblPayRate", "Crew = '" & [InCrew] & "'")

 

[Carl]

Thanks Ken. Delimiting the "InCrew" field did the trick. I t hink I ran
into this before but forgot about it. Thanks again.

The error that you get is common when the DLookup (same for other domain
functions) contains invalid syntax in the expression or contains reference
to a field that does not exist in the table.

Is Crew a text field in tblPayRate table? Assuming that it is, delimit the
InCrew value with ' characters:
curInRate = DLookup("Rate", "tblPayRate", "Crew = '" & [InCrew] & "'")

--

Ken Snell
<MS ACCESS MVP>

WHen running a DLOOKUP function in a module I get the above error. I
cannot
see where I've mis-coded anything and can't see anything different in this
code than in other code where the function works properly.

I am trying to retrieve the "Rate" from "tblPayRate" based on the "Crew"
field in "rstPay". My code is:

curInRate = DLookup("Rate", "tblPayRate", "Crew = " & [InCrew])

What might cause this error message?

Thanks