How to apply several filters to the form?

[Yodo]

I have a split form. To filter a datasheet table I use filter on my combo box after update event :


Code:
Me.Filter = "[WhateverFieldNameTheComboIsFiltering] = " & Chr(34) & Me.ComboNameHere & Chr(34)
Me.FilterOn = True

It works fine but when I want to apply another two filters ( another comboboxes), they work sort of against each other, I mean they are not filtering what first filter has selected and it results in a total mess because in datasheet I see names which not assigned to the seleced id.

[Homegrownandy]

Can you not use query criteria referencing the combo boxes? (forms query)

the update would only need to requery then.. or refresh. (I put in both as I forget which it is.)

[andy49]

Or you could create a myfilter line from each of the comboboxes to be run when a command button is pressed.

[Yodo]

Thank you for the answers! But what is a "myfilter line?" And I need to create a special button to filter that?

[andy49]

Easier to extend your original filter using " and " & whatever field = cbo2.value & " and "

And so on.

Advice. Use a string myfilter rather than me.filter directly.

It could get tricky and you'll be able to debug that string easier.