austenr
06-23-2010, 08:41 AM
I have a report that is all subreports. On a form I have a combo box that has three fields; STU, FirstName and LastName. On the form I have a command button as well.
What I am trying to figure out is how to open the sub reports and filter the records for the sub reports based on the conbo box selection. All of the sub reports use the STU as the join. So I was hoping to find a way that when the STU in the combo box is selected, show only those records in each sub report.
The STU is hidden on the combo box so all you see is FirstName and LastName.
Any ideas?
What I am trying to figure out is how to open the sub reports and filter the records for the sub reports based on the conbo box selection. All of the sub reports use the STU as the join. So I was hoping to find a way that when the STU in the combo box is selected, show only those records in each sub report.
The STU is hidden on the combo box so all you see is FirstName and LastName.
Any ideas?