Only show one record in Report

[jlc28]

I have built a form and a report. However, what I want is to print the report with only the one record that's showing in the form. For example, workorder number 300045 is displayed on my form, I want to be able to print this but in report form. However, everytime I try to do this, all the records print. How to I set the parameters to only print what's on the form screen. I know that I can just print the form screen but I don't it to look like that and there's another purpose that's just too much to get into. Any help would be appreciated.

Thanks.
Jen

 

[tickes]

you can create a query with a criteria [Enter workorder number:] and you will need to enter the workorder number. Then once you have done this you can build your report off of that query.

 

[tree_buddy]

You can also create a button with code similar to this..

Dim where as String

where = Form_FORMNAME.workorder

DoCmd.OpenReport "reportName", acViewNormal, , where

 

[jlc28]

Thanks to both of you, Tickles and Tree_Buddy. I've got it working now.