Robin,

Try using SQL statement in Grid

RecordSourceType = 4    && SQL Statment
RecordSource = Select * from mytable where tDate = ..

There is another way also which is Local View

Manoj


>Hi!
>
>Whats the best way of filtering whats in a grid? Say you have a grid based on a table, and you have another field which is a date field. Based on the date the enter you want to filter for that date on the grid.
>
>At the moment im using the set filter command but this seems a bot clumsy?
>
>Many thanks in advance
>
>RC
>Bespoke Software Systems