>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?
The best place to set it is in the form's init.
There is apparantely a speed difference in loading the form between setting the filter in the form::load() compared to the form::Init().
Setting the filter in the form::Init() makes the form pop up (load) faster.
I remember an article in FPA discussing this problem of optimization.