I have 4 workbooks. The first opens the second which opens the third which opens the fourth. When there's an error in any of the workbooks, I'd like my error handler to log the error in a text file and close workbooks 2 - 4.
p. 361 of Access 2003 VBA states: "When there is no error handler in the procedure in which the error occurs, VBA passes the error to the next highest procedure in the call chain."
I was not aware of this. If this is true then I should only need to place the code that closes workbooks 2 - 4 in the error handler of the entry point routine in the first workbook as opposed to every routine in every workbook. Can someone verify whether or not this is true?