Sending Form results to Report

[nhtraven]

I have a form, it's controlsource is a query. I have made a report, for each field in the report i have this in each field control source = [forms]![frmone]![fieldname] for each field tying to the corresponding field in form. This worked fine for my individual report, but the summary needs more then the first record. how would i go about sending all of the records to the report? would i save the recordsource? i am not sure how to do this

Any help is very much appreciated

Raven

 

[nhtraven]

ok i have messed around with this, and added this after the docmd line of code that opens the report.

Reports!rptname.RecordSource = Me.RecordSource

I cannot simply set the control source to the form because the query prompts users for a range, therefore, the user would have to enter the same info twice. but with this code it give this error message after the report is open

you cannot set the recordsource after printing has started.


were or HOW do i set the recordsource for report from the form?
i would appreciate any help thanks
Raven

 

[nhtraven]

I still havent been able to find any ifo on this, or any help. does anyone out there know how to send the recordsource <all of the records in the form> to a report?
thanks raven