If you must use a filter, the best place is probably the Filter property of the Cursor in the DE. You are much better off, though, using a parameterized view. Your current problem may be that the filter condition goes out of scope.
>I'm having trouble doing a set filter to command in init of a form with a private datasession. The form still displays all the records and ignores the filter condition. The same command works from the command window with the same table selected that is in the form DE.
>Where is the best place to set filter for a form?
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05