I have a form that has two subforms in a access database. This form is based on three tables where subform 1 uses master/child link to mainformID and subform2 uses master/child link to subform1ID. My forms works great open mainform select the ID needed it displays records in subform1 related to mainformID then select the record in subform1 to display the records in subform2 related to subform1ID. My dilemma I created a command button to print a report; using the same master/child links for the the three reports as the forms. The main and two sub reports are based on three queries with each query using one of the mainform tables, I use vba code that selects the mainformID to open report print preview all is well but the report opens and prints all records using the mainformID; how to do I filter the records to use the recordID selected from subform1 and then filter records selected from subform2?