a Varible that holds last operation

[easycode]

Hello all,

I have heard in another languajes that can hold in a varible whether the last operation was sucessful or not, is there such variable in access? I am using the wizard to import a table but if the user clicks on cancel i should do something else, but how can i know when the user clicked on cancel . Error 2501 did not work.
Any suggestions is appreciated. Thanks

 

[EBGreen]

Look at the Err object.

[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]

 

[easycode]

EBGreen, thanks for responding

yes i can use the Err Object, but this operation that i am talking about is not an error, if user clicks cancel in the wizard, acces does not recognize it as an error and continue doing the next line of code, and i need to do something when user does that.

Thanks again