DataSource.Filter (gb.db.form)

Property Filter As String

Returns or sets the Filter criteria property. An empty string (the default) accepts everything.

A Filter value acts like the WHERE clause of an SQL statement.

Remember to use DB.Subst which will properly delimit the filter text for the database being used.

For example:

Datasource.Filter = DB.Subst("Field = &1", Text)