>When i use this code i have syntax error
>

>Thisform.combo2.rowSource = ;
>"SELECT distinct code,descr, type  ;
>               FROM accounts;
>                WHERE type ="income";
>                                    INTO cursor combopapert"
>but when i try: WHERE type thisform.textt.value no error

>what is problem
>thanks

Hi,

The problem is in "" (double quotes) used twice in the same character expression. Use where type = 'income' instead and it should work.

Thisform.combo2.rowSource = ;
>"SELECT distinct code,descr, type  ;
>               FROM accounts;
>                WHERE type ='income';
>                                    INTO cursor combopapert"
>