Open and filter report

[Gary.]

I have a form that I use to filter and open a report
The main form control source is tblJobName
The sub form control source is tblElevation

I use a combo box on the main form to select the job name
I have a check box called [PrintElevation]
I need a button on the main form that when clicked will open a report that
is filtered for the job name an only the records that have the
[PrintElevation] checked
I am using Access 2007

Thanks for your help

 

[Ken Snell \(MVP\)]

See this sample database for how you can build a filtering clause for
opening a report, using controls on the form:

Building SQL string based on values entered into controls
http://www.accessmvp.com/KDSnell/SampleDBs.htm#FilterForm