Controlling report through VBA

[Ken Carignan]

This is a real puzzler! We have three sections (really
individual forms) on a report. The paper size is 8 1/2 X
11. We need to be able to examine the data and decide
whether to fill in the first form, then the second, then
the third. We use the debugger to cycle through the data
and everything seems fine.
The problem is that it only prints the data from the last
three records.
Is there any way we can force the report to print after
the three forms are filled in?
Thanks a lot, it seems simple, but it's driving us crazy.
Ken

 

[Jeff Boyce]

Ken

?You have forms on a report? Maybe this is a terminology disconnect...

One approach to handling reports that need selection/input is to create a
form (not a report), and base a query on the values selected/entered on the
form. That query then is the source for a report.

Or have I misunderstood what you're trying to do...?

Good luck

Jeff Boyce
<Access MVP>