Remember to set the Screen Updating property back to True when your macro ends.
This example demonstrates how turning off screen updating can make your code run faster.
A form's Resize event as well as firing when a user resizes a form, also fires when a form is loaded.
I read somewhere on google that screen updating defaults to true after a macro runs anyway, so I guess I didn't have to be turning it back on all the time.
If anyone else was trying to figure this out, thanks for your time.
Regards, jon [font=Verdana][size=2]You should not have to do all that.
What method (action) are you using to execute your queries in the macro?