Run-time error 2001 - in Access 2003 for an application that work.

[Run time error 2001]

I installed Access 2003 and tried to use some functions without chanaging
whatsoever. Most of them was working fine.

When I tried to use one of the forms I received an error message.
"Run-time error 2001 - you canceled the previous operation".

In debug the program showed a "DLOOK" function.
I verified the table to which the function was referring and the requested
record was available.

Does somebody has had this issue already and what could be the difference
between the "old" and "new" version of Access ?

Thanks in advance
Frans

 

[Allen Browne]

The error message almost certainly means that something is not quite right
with the DLookup() expressions, and it most likely the 3rd argument that is
correct.

The issue may involve other issues that are pecular to A2003. For example,
if the 3rd argument contained a reference to a control in a subform, you
could see this error in the latest version, even though it worked in the
previous versions.

Post the full expression giving the problem if it remains unsolved.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

in message
news:[email protected]...