I only want page 3 of a for to print. (1 Viewer)

How would I go about doing this? What is the code so that my command button only prints page 3 of a form?

Thanks a ton!

Brian,

Make a query that contains only the data on page three. Its
criteria should be that the primary key equals

=Forms![YourPageThreeForm]![YourKey]

Base a report on that query.

Put a command button on Page 3 or wherever and launch the
report.

Alternatively, you can base a report on the page three data.
Then when the command button is clicked you can specify the
criteria as:

"[YourPrimaryKey] = '" & Forms![YourPageThreeForm]![YourKey] & "'"

In this case YourKey is alphabetic, not numeric.

You can also search here for OpenReport for examples.

Wayne

Wayne,

thanks for the response. The problem is that mostly everything on page 3 is formula driven off of other things in the form. how would i make a query this way, since I can't bring over my formulas to the query. or would i just have to do that an redo all of the formulas?

Okay, so I made a macro that will print just page 3 of my form. That is great. The problem is that now it will only print page 3 of the first record of the form. I want it to print whichever page i am on. I then tried making a combo box and selecting from there, but it still will not work. Any suggestions would be greatly appreciated!

Forms aren't designed to be printed, as Wayne has already suggested, create a report, you can use the same formulas more or less