Filter Report Based on Checkbox

[BigNate]

Hello Everyone,

I relatively new to Access VBA and am getting nowhere with this issue.

I want to filter a report based on whether ornot the record's checkbox is checked or not.

The nameof my report is "QCTClaimLogReport". The name of my checkbox is"YesOption". The way I want to initiate this process is by clicking abutton called "OpenClaimReport" on a form called "MainMenu".

I know I have to do the DoCmd.openreport code and then insert a where clause, but the syntax for the where clause is the part that is killing me. Can someone please let me know how to do this?

Thank you!

 

[Joe4]

Please continue in your original post on this subject here: http://www.mrexcel.com/forum/microsoft-access/864737-print-current-record-report.html, per rule 9 here: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html

You have some replies there that you have not responded to.

Thanks