I am not sure what you mean about criteria string for report......
Code:
SELECT Opportunities.ID, Opportunities.Project, Opportunities.Customer, Opportunities.[Sales Responsibility], Opportunities.[Market Sector], Opportunities.Status, Opportunities.[Enquiry Date], Opportunities.[Bid Required By], Opportunities.[Quoted Value Total (£)], Opportunities.Comments, Opportunities.[Location Country], Opportunities.[Location City], Opportunities.[Customer Enquiry Reference], Opportunities.[Customer has order to place], Opportunities.[End User], Opportunities.[Complete AMB sets], Opportunities.[Cabinet Only], Opportunities.Commissioning, Opportunities.Engineering, Opportunities.[Maintenance Contract], Opportunities.[Remote tuning and monitoring], Opportunities.Spares, Opportunities.[Number of sets that would be ordered], Opportunities.[Bid Date], Opportunities.[Validity Expires], Opportunities.[Order Won date], Opportunities.[Order won value], Opportunities.[Follow-up Date], Opportunities.[Follow-up Person], Opportunities.[Follow-up Action], Opportunities.Closed
FROM Opportunities;
would it be this.- the recordsource for the report is this query.
I want the user to be able to apply the filter, view the records that the filter produces and then print just those records in a report. the report i am using is the report that is used by this form anyway-but when i click print it prints all records.