Report with subforms

[trackmedic]

What would be the best way to print a report from a form that has 2 subforms in it? I created a query and would like to choose from one of the catagories on the main form. What is happening is that I come up with a report with multiple entries of the same item (87 to be exact). I have only 1 entry in the form.

Any ideas?

 

[boblarson]

Your report may not be designed right. You should be using a query underlying the report, and not the table. Check out the Sorting and Grouping in the report (VIEW > SORTING AND GROUPING)