Temporarily interrupt macro

[Guest]

One step in my macro runs a find duplicates query. I want to delete
duplicates then continue with the macro. I'm relatvely new to macros, so
nothing too complex please.

 

[Arvin Meyer]

One step in my macro runs a find duplicates query. I want to delete
duplicates then continue with the macro. I'm relatvely new to macros, so
nothing too complex please.

It might be simpler for you to just build 2 separate macros. Run the first,
delete your dupliccates, then run the second. There is no built-in capacity
to stop and resume a macro, so you'd need to do that with a modal form, and
possibly some VBA code.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access