>my code si show below:
>case thisform.combo1.value= type
> SELECT table1
> SET ORDER TO type
> var1=thisform.text1.value
> set filter to type=ALLTRIM(var1)
> thisform.list1.requery
>case....
>endcase
>
>is that anything wrong in my code?
>Thanks a lot!!
Ng,
the requery line not end at the line, it start at the line,
then the SET FILTER TO expression must to be public.
But, when you filter the active key,
uses SET KEY TO ( or RANGE ),
it store the value and then it have not the
public expression problem,
and it is the fastest solution.
SELECT table1
SET ORDER TO type
SET KEY TO ALLTRIM(thisform.text1.value)
thisform.list1.requery
....
Fabio