>Dear All,
>
>I am sorry to ask this question again.
>I have already rewritten the part of code and used SQL statements as suggested.
>However, speed is not improved significantly.
>
>I hae traced the execution of the codes, and found it take quite a long time
>to refresh the form. I think the main problem occured when the program tries
>to show the filtered data onto the grids.
>
>Did anyone encounter this sort of problems before? How did you solve it.
>I will be grateful to hear any suggestion about this.
>
>Many thanks for all your help.
>
>Nest regards,
>Ron.
>
>

Try thisform.lockscreen = .t. before and = .f. after the code, this could help.


:)