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