Report button jump to current record set

[Kodama76]

Hi,

Not sure if this falls under Reports or forms but either way here goes....


I have a form with a button that when clicked previews a very plain report of all the record sets in the table. What I want it to do though is jump to the page that has the current record set's info on it....

Does that make sense? If there isn't a way to go directly to the current one's page by some key value then is there a way I can pass the record set number to the form and jump to that same page number (since it works out to be 1:1 ratio)?

Thanks

 

[Kodama76]

Thanks that led me to the answer.

For those looking to solve this problem too enter the design of your form and go to the event procedure for the preview or print button you created. You'll find a line that starts "docmd.openreport" without the quotes.

If you want the current record only then uses the following format:

docmd.openreport "name of the report", "print style",,"[query name]![field name]=[FORMS]![form name]![field name]"

the print style and the name of the report will already by filled in you just need to fill in the names between the brakets with your db's names. Good Luck and Thanks again Pat