Stop macro after selecting 'no'

N

naveehgreen

Joined
Jun 7, 2010
Messages
1
Reaction score
0
I have a macro that runs multiple queries (some of them are make table and update queries). Is it possible to stop the macro after selecting 'no'? For example, I am prompted with a notification saying Access will update 1000 rows, but I realize this is the wrong number, so I'd like to stop and investigate without having the other queries run. Instead of having to select 'no' ten or so more times to each of the other queries, I'd like the macro to stop after selecting 'no' the first time. Is this a possibility?

Thanks for your help.
 
Back
Top