print one page

[acde450]

I have placed a print preview command button on a form for printing the
report. However, the report that pops up shows all the records in that
table. How do I get just one record to pop up when the print preview button
is clicked. Thanks.

 

[Jeff Boyce]

What's the code behind your <Print Preview> button? If it was created by
using the command button wizard and only does print preview, you may have
told Access to print preview the form, not the report.

Consider changing the button to open the report in print preview AND to
filter the report to only show the record currently on display in the form.
This is part of the DoCmd.OpenReport,,, syntax (you can find it in Access
HELP).

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[acde450]

The print preview button was created with a wizard. How do I filter the
report to only show one record? How do I do a search for that in Access help?

 

[Jeff Boyce]

Open the form in design mode. Select the command button and get its
properties. Look for the "Click" event and follow the "..." (builder) link
to the VBA window - NOTE: if you haven't worked in code, this may not be
the time to learn! If you do use the code, highlight the OpenReport and
press F1 for HELP.

If you decide not to try the code approach, consider creating a macro that
uses the OpenReport action. It will offer parameters that let you
narrow/filter the report.

Regards

Jeff Boyce
Microsoft Office/Access MVP