Results 1 to 2 of 2
2001-03-27, 23:48 #1
- Join Date
- Jan 2001
- Thanked 0 Times in 0 Posts
printing a form and an attached subform
Not sure if this is possible but I'll ask anyway.. I have a main form with a subform on it.. The records are joined by ID fields. MainID is the Master link and SubID the Child.. This displays the matching ID numbers records from 2 tables on the form.. I would like to print, using a report, the current record of the form. Meaning print the data in the fields on the Main form and print the attached data in the fields of the subform.. I hope this makes sense.. Thanks for the help....
2001-03-28, 02:47 #2
- Join Date
- Dec 2000
- Sacramento, California, USA
- Thanked 1 Time in 1 Post
Re: printing a form and an attached subform
Build a report that produces the record groupings that you want (you may have to use a subreport to produce the equivalent of the subform, but not necessarily). Then you can use a button or some other method to open the report and pass it a wherecondition that includes the primary key for the current main record. That will limit the report to the main record and any related records in the subreport or underlying query.
Does that help, or haven't I made myself clear?Charlotte