J John Hipskind Sep 28, 2003 #1 How do I stop a macro when an Access error occurs as the macro is executing? Thanks. John
S Steve Schapel Sep 28, 2003 #2 John, Only one possibility here, I'm afraid. Figure out what's causing the error, and change the macro or the database so it doesn't happen again. Other than that, using a VBA procedure instead of a macro may give more flexibility in managing the error. - Steve Schapel, Microsoft Access MVP
John, Only one possibility here, I'm afraid. Figure out what's causing the error, and change the macro or the database so it doesn't happen again. Other than that, using a VBA procedure instead of a macro may give more flexibility in managing the error. - Steve Schapel, Microsoft Access MVP