View Full Version : Printing Tab controls (with subforms in them) to a report


mgonzalez
10-15-2008, 02:03 PM
Hello,

I have a frmUsers. This form has a combo box that lists employee names. When a name is selected, there is a Tab Control that has 5 tabs in it each containing subforms (subFrmPC, subFrmPrinter, subFrmMonitor, etc). I want to have the form send the data to a report I made.

The report I made uses a query (qryAll) that has all the records of the tables in it as its data source. I then set each section in the report to point to that data in the query.

I want to have the report print all the subforms in the tabbed control (ie: have the data in those forms at the current time get sent to the report (rptPrintRecord).

Any ideas???

Thanks!

--Matt

Uncle Gizmo
10-15-2008, 04:55 PM
Reports also support "sub reports" which are the reports equivalent of a sub form. Have you tried using these?