Subform good in PrintPreview but doesn't print?

[Birdman895]

I have a report with 2 subforms. The Main report is Client info.
Sub1 has ContactNotes for each client. It is in the detail section of Main, is in continuous mode, and is related to Main thru key ClientID. This prints good.
Sub2 is a signature block for the report. It is unrelated. It looks at the "Initials" field in ContactNotes, uses the date range and ClientID that Sub1 uses, and develops a list of the Clinicians that had contact with the client. their names and cert's are in a list form with a line for their signatures. This is working correctly and shows in print preview but will not print.
I have put it in the reportfooter on Main, in the reportfooter of Sub1, it calculates properly and shows in print preview but will not print!!!
Help

 

[billmeye]

Would you be willing to post this portion of your DB? I'm curious to see this happen.

 

[Birdman895]

Well I got it working. Subform2 had a form query with a nested query within it. The nested query ran a "SELECT DISTINCT" that I needed to run on field Initials_Clinician in Subform1. I thought the report generator might be having a problem making the nested query calculate so I changed the nested query to a Make Table query and ran it from code before the OpenReport command. It worked.
Thanks for responding!

 

[billmeye]

Glad to figured it out. Sometimes a Make Table is good simply to speed things up also.