Ok guys/gals, I'm just drawing up a blank today (just got over a cold). My boss want's a report print out of exactly how the structure of the form is. I know it's not a good idea to print forms as a report. What would be the easiest methode to print the form exactly as shown. It also has a subform in it. I could reinvent the wheel on the reports but my boss wants it asap. Is there a way to link from the current form to a duplicate of all the boxes to a report on the current record?
Need some guru advice on printing reports exactly as form
- Thread starter Ravenray
- Start date
No guru, but will give it a shot
If I correctly understand what you want to do, you can just change your page setup to Landscape and hit the print button. It should print your main form and the subforms (but it'll depend on the format and amount of information in your subforms). I'm not a guru, but that's how I've been able to print out forms. Hope it helps!
If I correctly understand what you want to do, you can just change your page setup to Landscape and hit the print button. It should print your main form and the subforms (but it'll depend on the format and amount of information in your subforms). I'm not a guru, but that's how I've been able to print out forms. Hope it helps!
- Local time
- Today, 06:22
- Joined
- Feb 19, 2002
- Messages
- 47,337
You will need to create a report with a subreport. When you print a report with a subreport, the subreport grows to print all its data. Subforms don't do that. So, if the subform only shows 5 of your 10 records, it won't grow and your printed copy will now show the non-visible 5 records.
- Local time
- Today, 06:22
- Joined
- Feb 19, 2002
- Messages
- 47,337
When you open the report with the OpenReport Method, use the where argument to set the criteria for the report.
