Opening a report with certain selected records from a continuous form

jjake

Registered User.
Local time
Today, 03:52
Joined
Oct 8, 2015
Messages
291
Hello,

I have a continuous form that shows a list of Preventive Maintenance Tasks (frmPMTasks)

I currently have a report that will print all tasks or all tasks that are due but what i would like is to be able to select certain tasks with a check box or something similar and generate a report based upon the selected records.

e.g

There are 5 tasks in the database but i only want to print 2 and 4 based upon selecting them.
 
Create a query that selects the records you need, and use that as the recordsource of the report.

Select * from MyTable where
RecordNumber in (2,4)

You could also use a form, let user select the record numbers from a Listbox, then build the query/recordsource based on the listbox selected items. Then open the report based on the newly constructed recordsource.
 

Users who are viewing this thread

Back
Top Bottom