Print/Preview current record in report/sub-report

[azgambit]

I've checked through the forums multiple times for something that will work, and so far, nothing has worked. I have a db with a single table and a single form (for data entry). However, because of the amount of data and the required format of the report, I have had to create a report with 3 sub-reports within it.

The report is a single main report with the 3 sub-report embedded within it.

What I need to do is be able to print and print preview only the current record.

Now, I can get it so that the main report only reflects the current record; however, the sub-reports continually want to show all the record in the table.

I have tried to filter the report using a string similar to that used on the main report, but then the sub-report doesn't show up at all. I have scoured the forums and tried every solution I could find.

Does anyone have any suggestions because I'm stumped.

 

[azgambit]

Disregard

I found the answer I was looking for. Instead of basing my report on the form itself, I created a filter query based on the form and based the report on the results of the query.

It all seems so easy in retrospect