I am upsizing an Access DB to SQL Server. Mindful that the objective is to reduce the network traffic I want to know what the best way of
setting up the Recordsource for subforms.

Obviously the starting point is to have a Stored procedure as the RecordSource. but does Access automatically ask SQL server just for the relevant records on the subform or is the whole Dataset sent across when the main form is opened and Access then sorts out the ones it wants.

Or would it be better to give the Record source for the Subform a parameter of the key and change it programmatically as the key on the main form changes.

for subforms,i:e one to many relationship,u will after upsizing,re-extablish the relationships in sql,n this is done,the moment the record source of the parent from is correct,then that of the sub form will be.i have assumed that the names iof the tables and fields remain the same i:e b4 and after upsizing