Report and subform?

[Jar80]

I have mainform that contains subform, now i have done one query that contains both forms then i made report on the query.

Now i have following problem!
When i add one row in the subform then report looks like ok (1 page is displayed) now when i add one more then report page number is 2 etc. I have added all information about the mainform in the report but that subform is added using subform/subreport function.

Subform meaning in this report is that it shows which products is included in the mainform.

Is there any way to get subform working in report or any better way to do it?

 

[LonnieJohnson]

I'm assuming you have two tables. One with the main information and another with the subform information. If so you can join the two tables in a query on the key field. Then create your report based on this query. You should choose the grouging option when building your report by using the report wizard. Pick a field such as customer name or something to group by and it will put all the sub info for each main entry under it.

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

Contact me at ==>lonniejohnson@prodev.us

May God bless you beyond your imagination!!!