Subreport multiple printing - help

[DavidCdp1]

Hi Everyone,


I have a form with a subform.
When I print this form
(I have two problems)
1. if there are no records in the subform, then there is no data in the report, eventhough there is some data in the form.
2. if there are more than one record in the subform, then I get more copies of the report accordingly.

Can anyone please help me regarding this.
Thanks in advance.
DavidCdp1

 

[flofi]

Check the RecordSource of your mainform. Probably, you included the table which your subform is based on into the RecordSource your mainform. So the underlying query of your mainform and your subform always have the same number of results. Remove the join you use in the mainform.

I hope that helps

flofi

 

[DavidCdp1]

I can't believe it is happening to me.
I went to report and changed the record source of main report(by removing the relation between two tables) as you said and IT IS WORKING.......GREEEEEET....THANK YOU VERY MUCH..

David Cdp1.