Error: You cancelled the previous operation (No I didn't!)

[Simon Harris]

Hi All,

This line of code, which sits within a function, in a module (Access
2003)...
MsgBox (DLookup("[gas_standing_charge]", "tbl_constants"))

Is causing this error...
"You cancelled the previous operation"

Don't geddit! Any ideas anyone?

Thanks!
Simon.

--
-
* Please reply to group for the benefit of all
* Found the answer to your own question? Post it!
* Get a useful reply to one of your posts?...post an answer to another one
* Search first, post later : http://www.google.co.uk/groups
* Want my email address? Ask me in a post...Cos2MuchSpamMakesUFat!

 

[Allen Browne]

The message indicates that one of the arguments is invalid.

Either there is no table named tbl_contants, or the table does not have a
field named gas_standing_charge.