cath_hopes
Registered User.
- Local time
- Today, 10:15
- Joined
- Oct 17, 2007
- Messages
- 52
Hello!
I have a print button on several forms that has the following code behind it:
DoCmd.OpenReport strDocName, acViewPreview, , strWhere
This means that a report version of the current form opens in Print Preview and the user can right click the report to print/ email as attachment/ export etc.
All this works fine except for my most complicated form which has a subform. The report it prints/ print previews is based on this form and has a corresponding subreport. Print Preview returns correct subreport data but #Error in the fields of the main part of the report. Then when I print it out, the main report fields correct themselves but the subreport becomes blank!!!
Has anyone come across this? Any ideas?
Thank you in advance,
Catherine
I have a print button on several forms that has the following code behind it:
DoCmd.OpenReport strDocName, acViewPreview, , strWhere
This means that a report version of the current form opens in Print Preview and the user can right click the report to print/ email as attachment/ export etc.
All this works fine except for my most complicated form which has a subform. The report it prints/ print previews is based on this form and has a corresponding subreport. Print Preview returns correct subreport data but #Error in the fields of the main part of the report. Then when I print it out, the main report fields correct themselves but the subreport becomes blank!!!
Has anyone come across this? Any ideas?
Thank you in advance,
Catherine
