Filter subform error

[dand_dd]

In the frmMain form I have 3 comboboxes and one subform. I have an error when i try to use the filter.
Can someone help me? It's urgent.

Thanks


Dan

[OBP]

I have added this

Me.tblNAP.Form.FilterOn = True

to your code prior to changing the Filter with this

Me.tblNAP.Form.Filter = sQuery & GStrFilter & sOrderBy

Which The VBA Editor Accepts, but it produces an SQL Syntax Error.