Peter,

You can create a view in your database. This view will return only the records you need. You can affect this view to the Grid with a command like this :

ThisForm.Wsgrid1.RECORDSOURCE = "VIEWNAME"

For your information (if you don't know) You can use this view as a nomal table, so you can make some update on field.

Hope this help!