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

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13250-error-you-cancelled-previous-operation-no.html
* Found the answer to your own question? Post it!
* Get a useful reply to one of your posts?...post an answer to another one
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13250
* Search first, post later : http://www.google.co.uk/groups
* Want my email address? Ask me in a post...Cos2MuchSpamMakesUFat!

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

The message indicates that one of the arguments is invalid.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13250

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Simon Harris" wrote in message
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13250
news:%237Aq3%230pGHA.1548@TK2MSFTNGP04.phx.gbl...
> 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.