Datasheet won't update based on combo box

[menken]

I have a split form based on a query. In the header I have a combo box that works as a filter for the query. So when I change the value of the combo box I expect the datasheet to update (On Change Event Requery). Now the problem is that the datasheet doesn't reflect the new filter.

When I execute the query itself (which is linked to the combo box) everything works fine. Also, when I update an underlying table of the query (e.g., add a new entry) and then change the value of the combo box, the new entry will show up in the datasheet, but not the filter. So based on that I conclude that the query is right and also the event works.

Any idea what's going on? I'm getting insane over this...

[ranman256]

Don't use a split sheet. I use a continuous form,the combo (in the form header) changes,and the filter works...

sub cboBox_afterupdate()
If IsNull(cboBox) then 
    Me.filterOn= false
else
   Me.filter ="[id]=" & cboBox
   Me.filterOn= true
end sub

[Missinglinq]

What code are you using to do the filtering?

Linq ;0)>

[menken]

It's a simple WHERE-clause in the query:

WHERE (((Dienstleistungen.DienstleistungID)=[Forms]![F_Lieferanten]![DienstleistungName])) OR ((([Forms]![F_Lieferanten]![DienstleistungName]) Is Null))

And for the combo box I have defined an On Change event procedure:

Private Sub DienstleistungName_Change()
    Form_F_Lieferanten.Requery
End Sub

[menken]

For some mysterious reason it works now, even though I haven't changed anything at all. Let's hope it stays like that...