Form code not behaving correctly with Split Form view

[flect]

Howdy

I have a new piece of filter code that's working great on reports and on forms, however it's not working correctly with split form view.

The code works fine if you double click the textbox on the form, but not if you click the same field in the split view.

Private Sub txtStockType_DblClick(Cancel As Integer)
    If Me.FilterOn = True Then
        Me.FilterOn = False
            Else
        Me.Filter = "stockcat=" & "'" & Me.stockcat & "'"
        Me.FilterOn = True
     End If
End Sub

What happens when clicking on the split view field is that it DOES update the filter to the correct value, it seems to apply the filter, but the form does not reflect this unless I manually click 'toggle filter'

I've tried using refresh/requery/repaint but it's still the same result.

Any ideas why this is happening and how to work around it, or alternatively, is it possible to directly code the table field to do the same thing?