>Hi Kimberly.
>
>
>>> I encountered an interesting problem today...I have a table with a grid control in a form that is meant to display the transactions for an item (Balance Forward, Incoming and outgoing). This display can be all, or a date range. The grid didn't what to display the filtered records, but always displayed all the records. <<
>
>You have to move the record pointer for the filter to take effect and then SetFocus to the grid.
>
>However, the filter will not be Rushmore optimizable in a grid. So if you have a lot of records, using a filter on the RecordSource of the grid will be slow. You would be better off to use a paramterized view.
>
>Marcia

Marcia, I agree with your suggestion about using a parameterized view or maybe simply creating a cursor. I have only one instance in one large app where a FILTER is used and none in another large app. I try to avoid it.

Steve