Filter on Option Group settings

[Sgt Bilkp]

Hi,

After managing to work out the bound combo box problems i had earlier, i have now stumbled on another problem, which will turn out to be a very simple answer i am guessing.

I have an Option group with three options, "In Service, Faulty, Decommissioned" (opt_service, opt_faulty, opt_decom).

I want to be able to apply a filter by clicking on a macro button to only show those records with machinery that is faulty or in service etc, etc

 

[ted.martin]

The 3 options will have an Option Group value of 1, 2 or 3. When you run your filter - (how are you doing this), filter on the Option Group Value.