Print Form in Access '97?

[Dave Osborne]

My users use an Access '97 database that I created. One of my forms is comprised of a main form and a subform containing one to many detail records (continuous form). My users wanted me to add a "Print Form" button to the bottom of the main form to do a basic "screen print" of the form. Seems simple enough!

After a fair amount of research, it seems the easiest way to handle this is to use "DoCmd.PrintOut", which is what I did.

Here's the problem: Let's assume the subform contains 5 detail records which easily would fit on one printed page. However, when I call "DoCmd.PrintOut" I get 5 pages of printed output! The pages are laid out as follows:

Page 1 - Main Form Header Section AND All SubForm Detail Records.
Page 2 - All SubForm Detail Records only.
Page 3 - All SubForm Detail Records only.
Page 4 - All SubForm Detail Records only.
Page 5 - All SubForm Detail Records AND Main Form Footer Section.

This same pattern follows no matter how many detail records there are. I've tried many various property settings to no avail.

Any Ideas??

Thanks!
Dave