It sounds like you're using the form's DE to open the table. If you go to the properties for the table that's used as the grid's RecordSource, you'll find a Filter property. But beware! Filtered tables in grids aren't optimizable.

>I have a GRID with a table being the recordsource (Type = Table). I want to set a filter on the table. Where or how can you do this? It is not open in a workarea, so you can't use SET FILTER TO ...
>
>Thanks for any help you have!
>Colombo.