Preview button

[Andrea]

I have a button on a form that when clicked, will run a
parameter query that will ask the user for the ID number
of the form (underlying table)and then it will generate a
report for that ID. Is there a way that I can create a
button that when clicked, it will send the user to print
preview for the current ID being viewed?

 

[Jeff Boyce]

Andrea

Check Access HELP on the following command syntax:

DoCmd.OpenReport ,,,

there are values you can use to open in Preview, and a "Where" clause you
can use to pass the value of the form's current ID to the report being
opened.

NOTE: if it is your REPORT that calls the parameterized query that asks for
ID, you'll need a new report that is based on all records. This is what
you'll be passing the ID to.