Prints same query records repeatedly

[rproactive]

Hi all-

How can preview printout from VBA code? I am wasting a bunch of paper trouble shooting a Report problem.

The report problem is that the same query records are printed in details about 15 times. What on earth could be happening?

Any ideas appreciated

 

[rproactive]

In Report preview if I set Page Setup columns from 1 to 5 the number of duplicates is reduced to 3.

Further if I set Column Layout fro down, then across to across then down I finally only geet 1 copy

What is going on??
Would also like to learn how to do a print preview from Form that has a print command button .

Thanks again

 

[rproactive]

There is no separate sub report listed under Report Objects. My Report R_DepositSlip (whose record sourse is M_DepositSlip) has a single control in Detail Section which is a subform named srC_Q_ReportDepositSlip with following properties:
Source Object: Query.Q_ReportDepositSlip
Link Child Fields: blank
Link Master Fields: blank

Mainform is F_Deposit slip whose record source is M_DepositSlip. It has a subforms.

Perhaps I am confused as to what is a subform?
Again, Thanks for your ideas.

 

[dhookom]

Isn't this the same issues as you are struggling with in thread703-1310997?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]