If memory serves me well, the filter expression can follow the same rules as
the DataColumn.Expression property. The following MSDN reference for that
property has the complete reference on the rules for the filtering
expression:
http://msdn.microsoft.com/library/de...ssiontopic.asp
Note that you can AND expressions together.
--
HTH,
Kevin Spencer
Microsoft MVP
Professional Development Numbskull
Nyuck nyuck nyuck
"mafandon" <ma******@discussions.microsoft.com> wrote in message
news:F0**********************************@microsof t.com...
Is there a way to perform a bindingsource.filter on multiple inputs? For
example: I would like the user to be able to put something like <Smith,
Jones, Gates> into a textbox and have the datagridview filter the lastname
column to just those entries.
My code is simple right now:
dim strFilterLastName as string = me.txtbxLastName.text
me.qryWorkListBindingSource.Filter = "empnamLastName ='" &
strFilterLastName
& "'"
Thank you for any advice.