Prevent Query Update until I press refresh button

[efandango]

I have a fully working form/Query that is not linked to any other form. But
whenever I go to another master record, the form/query updates/refreshes
giving me a new dataset. How can I prevent it from doing this?

I have a refresh button that works fine for this requirement, so just need
help on simply stopping it from refreshing automatically.

 

[Michel Walsh]

There is nothing such as a 'master' record.

If you are using a form with a subform, it is usual to get the subform
connected (linked) to the subform. The properties 'Link Child Fields' and
'Link Master Fields' govern the synchronization process between the form
and its subform.

If 'master record' is an expression you made up to describe your reality,
can you supply more details.

Note that is it possible that your form's events (in particular, the
AfterUpdate event of the FORM (not of one of its control, but of the form
itself) has code to requery the form, such as Me.Requery.



Vanderghast, Access MVP

 

[efandango]

As was mentioned, the form is not linked, and is not required to be. It is
more of a report style form, simply displaying a list of random records drawn
from a query for the user to read from, but not edit/or input data to.

The 'Master record' is the Main Form fieldset, most notably [Run_No]. This
field and its associated fields (including primary number field) is what I
reffered to as the 'Master record'. Perhaps it was the wrong use of phrase,
but I couldn't think what else to call it.

Anyhow, as I scroll through each page of 'main record', my form in question
also refreshes/requeries itself. This form has no Master/Child setting.
Neither does it have any event settings in its properties. Which leaves me
baffled as to why it gets requeried everytime I move from one main record to
another.