Stopping a Query from running automatically

[steve1111]

Hello,

I have an unusual situation I haven't seen and hope to get some help on. I have a form with tab set one tab called "Enter Receipt" and another that houses 2 queries called "Reconcile". My issue is when I open that form, I have an On Current Macro to go to NEW record for my Enter Receipt, but I am getting a delay while the query status bar runs the other queries. I was hoping not to have those ran until i enter the parameters and hit the run button on that "reconcile tab".

Everything else works, i just need the queries to keep from running when i load the form.

PS my queries i moved from EDITED to NO LOCKS thinking the On Current new record may affected them, not change in delay.

Thanks for any help.

 

[CJ_London]

Not sure how you would do it in a macro (I don't use them) but in VBA you would use something like

if not me.newrecord then
   ...run query
end if

 

[namliam]

How about
1) Creating a dummy table that "looks the same" but doesnt hold any data, you bind the form to that table initially on opening the form and apply the "proper" recordsource to the form when you hit the reconsile button
2)
Add a filter to the form that is 1=2, which is always false, which should mean the form will not show anything, thus shouldnt delay your opening the form anymore.

 

[steve1111]

Thanks everyone, i will give both of these methods a shot and see what i can do