Code:
DLookup("[RateValue]", "[Rates]", "[Rate]=" & CStr(CRegion))
The field is not null, it contains a 'Number' value with 2 decimal places. It is going into a double variable.
I have also tried it without the [], same result.
...
1 result in 0.0014 seconds.
-
"You cancelled the previous operation" Error on Dlookup
I have the following Dlookup statement:
I get the error: "You cancelled the previous operation".
The field is not null, it contains a 'Number' value with 2 decimal places. It is going into a double variable.
I have also tried it without the [], same result.
...