We have no way to use querydef as subform soure
Problem
Option 1 use ado - disadvantage - no master child
Option 2 - linked table - disadvantage - no server side filter, can bring millions of records to client - stupid and ineffective
Suggest
Option 3 - querydef as standard snapshot recordset for all forms and subforms and server side filter
You are 15 years behind.