Filter query/option group

[Lou P]

Filter Macro/option group

Looking for assistance please.

Using MS Access 2007 I'm trying to filter the [HWEvents] contained in a subform (subHWEvents) which is in a control (ctlHWEvents) on the main form (frmHW).

The Record Source for the subform is a query (qryHWEvents).

The Option Group on the subform (optEventType) has 5 options:
Maintenance = 1
CASREP = 2
Installation = 3
Miscellaneous = 4
Shipping = 5

These values are saved to [tblEvents].[EventType]

The Filter Option Group (EventTypeFilters) contains 6 buttons which translate to the ApplyFilter & ShowAllRecords "Actions" in the underlying macro (mcrEventSort).

Maintenance = 1 - ApplyFilter
CASREP = 2 - ApplyFilter
Installation = 3 - ApplyFilter
Miscellaneous = 4 - ApplyFilter
Shipping = 5 - ApplyFilter
All = 6 - ShowAllRecords

The EventTypeFilters buttons are located on the subform footer.

I've used the qryHWEvents as the Filter Name, the [EventType]=1 etc.
and the Control Name every possible combination there is.

I get ERROR 2950..."Apply Filter action requires a valid control name that corresponds to a subform or subreport."

To list just a few...

[EventType]=Forms![frmHW]![ctlHWEvents]![EventType]=1 etc...

Leaving it blank as the option group is on the subform

[EventType]=[ctlHWEvents]![EventType]=1

[EventType]=[ctlHWEvents].[EventType]=1

Still the same ERROR 2950.

I've also left the Filter Name blank & used the Filter Option Group (optEventType) as the Filter Name.

What am I doing wrong?