Someone stop my subforms from requerying

[efandango]

I have two subforms that have no master/child links; but every time I move
the master page to a new set of records, the two subforms refresh.

I don’t want them to do this as they are completely independent of the
master records, and are simply used for the purpose of displaying
‘read-only’ query derived records for viewing purpose.

When I want to refresh them, I use the ‘Refresh’ button, which requeries the
forms based on values in certain combo boxes on the main form.

How can I stop this maddening behavior?

Mainform:
Frm_Runs

Sub Forms:
frm_Point_2_Point_A
frm_Point_2_Point_B



This is the sql that drives the subforms:

SELECT TOP 9 Qry_Point_2_Point.Run_No, Qry_Point_2_Point.Point_ID, 1 AS
[Set], Qry_Point_2_Point.Run_point_Venue,
Qry_Point_2_Point.Run_point_Address, Qry_Point_2_Point.Run_Point_Postcode,
Qry_Point_2_Point.Area, Qry_Point_2_Point.District,
Qry_Point_2_Point.Point_Type
FROM Qry_Point_2_Point
ORDER BY Rnd([Point_ID]);

 

[Jeff Boyce]

If the main form and subforms aren't linked by parent/child fields, I'm
guessing there's some code somewhere (I'd look in the main form) that
explicitly tells the subforms to refresh.

Regards

Jeff Boyce
Microsoft Office/Access MVP