I am using ADP and have a main form and a subform. The SQL server is on a different computer somewhere on the LAN. The ADP file is on the local computer.
MAIN FORM: The recordsource is a parameterized query returning a single record.
SUBFORM: The recordsource is a query with no parameters. It will seem to return hundreds of records. However, the link fields of this subform has been set, thereby serving as a parameter to the subform's recordsource.
The question: When the adp retrieves the recordset for the subform, does the SQL server return all the records specified by the subform's recordsource? Or does it return just the records "parameterized" by the link fields?
MAIN FORM: The recordsource is a parameterized query returning a single record.
SUBFORM: The recordsource is a query with no parameters. It will seem to return hundreds of records. However, the link fields of this subform has been set, thereby serving as a parameter to the subform's recordsource.
The question: When the adp retrieves the recordset for the subform, does the SQL server return all the records specified by the subform's recordsource? Or does it return just the records "parameterized" by the link fields?