Hi,

I wonder can I do this....I have a form which views data from a number of tables, and shows a lot of data. I then use simple criteria to narrow my results down and view the data I am looking for...fine....now I want to add a button on the form to produce a report which will only include the data that is currently displayed. In other words to carry the criteria into the report.

Anyone ?

Thanks :o

Hopefully the record being dispalyed on the form has a unique index. Use that index as a filter in the report's recordsource or Filter property (with the reports FilterOn property set to True).