Form/Report printing problems

[Guest]

I wonder if anyone can help me, I'm trying to print documents created in
access forms (or reports) and the problem is that it prints as if it's one
large document rather than a 1000 or so smaller documents. I actually want to
staple the results (it's a kind of mailmerge from multiple data sources), but
currently the printer will only try to staple once the entire job is finished.

Thanks,
Simon

 

[Rick B]

You would have to give us more details. If you are printing one report,
then how would you expect the printer to know differently? Are you doing
this through code? Much more detail needed please.

 

[Guest]

Sorry, I'll try and elaborate. Originally I created a form, which is
basically a letter on the first page (with name and address etc from say
table A), and the second page contains a list of information unique to that
individual (from table B). There are around 1000 records (letters) that need
printing, and I'm looking for a way to tell the printer that each record is a
new print job, therefore forcing it to staple each letter. I've also
recreated the letter as a report, and the problem is the same.

Thanks,
Simon