Printing Sub-Form

[tacoboy42]

i have a search form with a sub form displaying the results, how can i send the results to a report to print out or just print the results?

 

[Smart]

You could create a report that has no record source, then place fields on the report to contain the information on the sub report.

On the report fields data tab ,control source type this (replace form and field names with yours)

=Forms![Yourmainform]![yoursubform]![yoursubformfield]

 

[tacoboy42]

do you think you could show me on this example then repost it?

 

[Smart]

If you open your search form and click on the magnifying glass a report will be previewed. Hope its what you are after

 

[andywhittle]

print

Hi Smart or anyone who else that can help.

I have ammended Gromits example and have tried to do the view a report like Smart has mentioned.

However when I do it - every record is shown on the report not just the filtered records.

Please help I can't see how my version differs from Smarts as his does filter

Thanks in advance - I have attached my database

 

[Wulf13]

Has anybody figured this syntax for this yet? I too am having the same problem.