keeping focus on main form while queries are running

[ronda]

I'm sure there is a simple solution - but everything I have tried hasn't worked.
I have a command button on my main form that opens up a popup form. On the popup form the user makes various selections and clicks on another command button(on the popup form). That button is linked to a macro - that runs several queries.

The problem I am having is when the macro starts to run - the main form is maximized again (so now it doesn't take up the full screen - just a part of the screen) and some of the queries start flashing in front of the form.

I know how to maximize the form once the popup form closes - that's not a problem. I just cant figure out how to keep the focus on the main form and in front of all the queries as they are running.

 

[xezekielx]

did you try this?

DoCmd.Echo False
'Run macro here
DoCmd.Echo True

 

[ronda]

Thanks for your reply!
I had tried using echo on/off and was still have the issue.

I finally found out what was happening when I stepped through each query on the macro - I had put in a select query (which obviously wasn't needed) and thats what was causing it to show up.