Print a report using data from a subform

[CarlyA]

I have a form &quot;main&quot;, that has a subfrom.&nbsp;&nbsp;A sql string, which has a lot of variables, is created from the criteria you choose from the &quot;main&quot; form.&nbsp;&nbsp;Those results fill the subform.&nbsp;&nbsp;I want to print a specific report using the data from the subform.<br><br>Thanks

 

[Chopper]

And you want help with...? <p>-Chopper<br><a href=mailto: > </a><br><a href= > </a><br>

 

[CarlyA]

I need help with printing the report using the data from the subform.&nbsp;&nbsp;I keep getting every record in the database in the printout and not just the ones in the subform.&nbsp;&nbsp;I've tried linking the report to the subform results but it doesn't acknowledge it.&nbsp;&nbsp;I have the &quot;main&quot; form open -- so that isn't the problem. <br><br>I'm calling the print command from a command button on &quot;main&quot;.&nbsp;&nbsp;Should I create the record source in the sub assoc. with the command button?&nbsp;&nbsp;I started to do that but I really don't know what the correct code should be.&nbsp;&nbsp;What I've come up with so far doesn't work.<br><br>Thanks, Carly