Hello and thanks in advance for your help! This is the first of 2 questions I will be posting related to this topic.
I have a form that tracks clinical trials (new drug/device testing). A subform is used to track the people working on that clinical trial. Usually only one physician is assigned to the clinical trial but occasionally there is more than one. I have a report (a cover letter) that users can print from the form that is currently based on the main form key field (it prints the report based on the open record using where condition in macro[CTNum]=[Forms]![frmCT]![CTNum]). The detail section of the report contains physician name and address.The report works dandy except when there is more than one physician assigned to the clinical trial. In this case I get repeated information for each physician/address down the page causing the report to run to two pages. This is not good.
What I would like is to have a separate report/letter print for each physician entered in the subform. The user thinks this is a good idea, too. To make matters worse they would like this to happen:
Let's say there are 3 physicians for a certain clinical trial (based on subform entries)...
1). Print the report/letter for physician1
2). Include "cc:" for each physician's report which would look like: "cc: physician2, physician3"
then, print report/letter for physician2 and include, "cc: physician1, physician3" in the report, etc., etc.
Any ideas?
I have a form that tracks clinical trials (new drug/device testing). A subform is used to track the people working on that clinical trial. Usually only one physician is assigned to the clinical trial but occasionally there is more than one. I have a report (a cover letter) that users can print from the form that is currently based on the main form key field (it prints the report based on the open record using where condition in macro[CTNum]=[Forms]![frmCT]![CTNum]). The detail section of the report contains physician name and address.The report works dandy except when there is more than one physician assigned to the clinical trial. In this case I get repeated information for each physician/address down the page causing the report to run to two pages. This is not good.
What I would like is to have a separate report/letter print for each physician entered in the subform. The user thinks this is a good idea, too. To make matters worse they would like this to happen:
Let's say there are 3 physicians for a certain clinical trial (based on subform entries)...
1). Print the report/letter for physician1
2). Include "cc:" for each physician's report which would look like: "cc: physician2, physician3"
then, print report/letter for physician2 and include, "cc: physician1, physician3" in the report, etc., etc.
Any ideas?
