Solved Report filtering (1 Viewer)

[Atthe]

Hi All,

I have a form which generates a report based on combobox selection, I need to be able to filter based on the entry in 1 field which is to be selected with a option control. I have set this up with queries but not sure how to best handle the multiple options?

At the minute for the first option I have:

DoCmd.OpenReport "rptSetupSheet", acPreview, "FilterTooling", Me.filtertooling = True

This works fine when true but if false the report is blank, Do I need an If statement to loop through the different options? or is there an easier way to handle this

Thanks for any help/advice

 

[CJ_London]

You need to make it equal to something

perhaps

‘[toolingtype]=“ & me.filtertooling

 

[arnelgp]

you should be able to filter by concatenating your Options control:

DoCmd.OpenReport "rptSetupSheet", acPreview, "FilterTooling", _
"[filterToolinFieldName] = " & Nz(Me.filtertooling, False) & " And " & _
"[AnotherYesNoFieldName] = " & Nz(Me!anotherOptionControlNameHere, False) & " And " & _
"[YetAnotherYesNoFieldName] = " & Nz(Me.YetAnotherOptionControlNameHere, False)

 

[Atthe]

Thankyou !