Menu item to run report of selected records

[pinklisa]

Hello, and thank you for any assistance you can provide.

I have created a navigation menu for my database. I want to add an option to print a report by viewing a list of records and selecting the ones to be printed.

I have a form with a list-box, which I can view the records and select them, but not certain how to pass the selection on to the button I've created to run the report.

Thanks,
L.

 

[Ranman256]

create a append query, when you dbl-click the item in the list, it add it to a 'pick' table.
All items in the picked table are joined with the data table, the query /report will pull ONLY those items.

similar to the diagaram