Preventing underlying form query from auto refreshing/requerying?

[efandango]

I have a subform linked to an underlying query. Everytime I move the Main
form record, it changes the subforms records too. The subform is not
Parent/Child linked to the main form. But it does use a criteria linked to an
unbound box on the main form.

How can I prevent the subform's query from requerying until say, the user
presses a button or some other similar soultion?

 

[Jeff Boyce]

I'm not understanding the logic of what you seem to be asking to do...

It sounds like you have one record showing on your main form, plus a subform
with related records. Then you change the record showing on your main form,
but you DON'T want the subform to show the records related to that new main
form record?!

Why? What will having the old record's subform records showing allow you to
do with the new mainform record?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[efandango]

Jeff,

The records on my subform do not relate to records on my mainform. Though
the subform is on a Tab Page of the mainform. The subform relies on a query
which updates everytime I navigate the master records back or forwards.

There is no need for this subform to refresh/update its records and is very
undesirable to do so. Also, It's query is quite complex and consequently
slows the rest of the programme/forms. All in all, it is a pain that I can't
stop it from updating. Ideally I want it not to update until a requery button
is pushed on the subform. How can I achieve this?