Displaying Error Codes in the immediate window

[lloyd33]

I would like to output an error code to the immediate window, however the following code does not work what am I doing wrong.

I placed the following code in the on error event but nothing is output to the immediate window.

Debug.Print "DataErr = "; DataErr

 

[Mile-O]

Debug.Print Err.Number

 

[lloyd33]

thanks

Much appreciated. Do you know of an instance when the debug number would not be printed. I placed this code on a form using a undo event and the error message was shown on screen saying this "The command or action 'Undo' isn't available now." No error number was printed can you help.