next button

[nishant.dhruve]

I want to program next button such that what ever check box are selected according to name of that check box it should open a report with all those selected filter and no other record are shown except that filter.


can anyone suggest me code on it?

[rpeare]

in the query driving your report have a formula something like:

SHOWME: iif(forms!FORMNAME![General Prod] = -1 and [Area of SOP] = 'General Prod', 1, 0) + iif(forms!FORMNAME![Granulation] = -1 and [Area of SOP] = 'Granulation', 1, 0)

Then apply a criteria of

>=1 to the SHOWME field

[nishant.dhruve]

Hi

I tried to enter this but is showing up some syntax error
fyi: my report name is rptsopsearch

[rpeare]

no

the >=1 goes in the CRITERIA line of your query driving the report not in the vba code.