Multiple record selection from cbo box 1

[ChiefJones]

I am really hoping I can get some help from this forum. I have a query that runs a report consisting of eight queries. This all works fine. However, now they want to be able to pick and choose items (600+) to appear on the report instead of all records. This report presents data pertaining to each of the records in the data base.

Any assistance would be greatly appreciated.

Thanks in advance.

 

[ajdesalvo]

Create a temporary table for the report recordsource.

Then append the results of the 8 queries to that table.

Add one additional field to the temporary table, call it "Selected" (or something similar) and make it Yes/No type.

Then create a form that the users can see the results of your queries, and allow them to check off the records they wish to see in the report.

The report's recordsource would be everything from the temporary table that has "Selected" = Yes.

Hope this helped!
Anthony J. DeSalvo
President - ScottTech Software
"Integrating Technology with Business"

 

[ChiefJones]

Never would have looked at it that way. I'll give that a shot. Thank you.

Ancil "Doc" Jones
Programmer

"Enjoy our freedom. Thank a Vet"