Query For a Report Problem

[sondriven]

I want to make a report with a query from a Form with a Subform in it.

I built a query but my results are showing a duplicate of the top section of my form for every entry in the subform.

If I simply right click the Form and "Save As" a report, I can get the report that way, but when I go to edit the report my subform changes to the way the report is. For example, my subform has some color in it and I dont want color in the report or any shades for that matter. So I take the color out of the report that was built from the Form and the Subform also changes.

Need some help.

 

[Rich]

Save the subform as a report separately, simply change the name of the source object for the sub on the main report to the new subReport