Select records to filter in report (1 Viewer)

[cktcPeterson]

I currently have a subform in datasheet with a check boxes per record.

I want to check the box
Click command button
Open report
Only display records that were checked.

Main Form: RecurringPayment
Subform: frmRecurringPayment_Subform
Query: QryRequeste Course
Report: rptRequestedCourseComplete

Can someone please assist me in navigating this?

 

[CJ_London]

Not much to go on so a vague answer.

assuming your subform is.based on the same table as used in your report then you should be able to use something like

“checkboxname=True”

In the where parameter of the openreport command

note this method is not suitable for a multi user app

 

[Pat Hartman]

Keep in mind that the checkbox must be a bound field. Then you will need to run an update query to "uncheck" the selected records. Also, this method will not work if you have multiple users who might want to run the report at the same time.