Passing Filtered Subform to Query to generate multi-page reports

[Bassbase]

Hi All,

First of all my apologies for the title, i wasn't quite sure how to word what im after in a shortened version!

I have a filtered form with a sub form displaying only non-printed invoices.

The sub-form has a check-box (which is how the form is filtered) to only show unchecked (not yet printed) invoices.

All i want to do is print only the invoices visible in the sub-form.

I've setup the report to link to a query and the report is all setup, i just can't get the query to function how i want it to!

I've got this SQL code for the Query.

SELECT tblOrderForm.OrderNo, *
FROM tblOrderForm INNER JOIN tblOrderDetail ON tblOrderForm.OrderNo = tblOrderDetail.OrderNo
WHERE (((tblOrderForm.OrderNo)=[Forms]![Export Orders]![ExportSub].[form].[OrderNo]));

However this only shows the field with focus. I would like it to display ALL data in the subform.

Hope i've explained it clearly enough.

Many thanks for your help!

James

 

[Bassbase]

Sorry to all.

I had a 2day long moron moment.

I just used the filter i used on the form in the query parameters.

sorry all!