Here is my setup:

1) Search form - which query for records
2) Result form - contain records base on the search form

Here is what I want:

A command button to Preview Print or Print all the records base on the results form.

Here the code that i have been using:

DoCmd.OpenReport "ReportName", acViewPreview, , "_ID = " & Me._ID

Some how it only return one record in the report. I need it to return all the record in the result form.

It's a urgent help. thank guy.

Dai

It is returning any record that matches the _ID field on the form. If that is not what you want, change the criteria.