Print report of one record

[Khushalay]

Hi Friends

I have a report of over 2000 records. But I want to take a print of one record at a particular time. Now, it gets very difficult and time consuming to search that record in a print preview and then print.

Is there any way to have a find/search field in print preview where that particular record can be searched and printed?

Thanking you in advance.

 

[MrHans]

I think you are referring to a filter or linkcriteria.
Normally you would open your report from a form using a command button.

If you use the wizard to create this button it will ask you if a specific record should be opened.

With for example a combobox on the form you can select what record you want to see in the report.

Basically: Docmd.openreport, reportname, criteria

 

[Khushalay]

I put

DoCmd.OpenReport CartonMaker SalesOrderNo

Where CartonMaker is the report name and SalesOrderNo is the name of the field on the basis of which I want to filter but it shows an error.

 

[pbaldy]

It would look like this:

http://www.baldyweb.com/wherecondition.htm