Error "You Cancelled the previous operation"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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] & "'")
 
Thanks Ken. Delimiting the "InCrew" field did the trick. I t hink I ran
into this before but forgot about it. Thanks again.

Ken Snell said:
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>

Carl said:
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
Click to expand...
Click to expand...
 
Back
Top