do you need to display all the record information in subform1, if not so, why don't you use a combobox with row source of the records from query of subform1, and put this combo in the criteria of query for subform2, that way it will filter the records you need whenever you select them in the...