I have a form whose data source is a query that produces a subset of table 1. The subform's data source is table 2 and is linked to the form record by a common ID. When the form opens to its first record the subform is blank although there are corresponding records. If I scroll the form to the...