BindingSource.Filter

See more:

VB

Hi,

I am able to filter records using BindingSource.Filter = "FIELD like ENTRY".

So in this case only the records which match "ENTRY" in "FIELD" are displayed and the rest of the records are discarded.

I want to know what the simplest way is, to do the exact opposite.

I want the filter to discard the records which contain "ENTRY" in "FIELD" but display everything else.
So instead of using "FIELD like ENTRY" is there something similar to "FIELD unlike ENTRY" or "FIELD not like ENTRY"?

My Current Code:

TblAccomadationBindingSource1.Filter = "Site like '" & ComboBox5.Text & "*'"


Please Help


Marco