dear tamar
my problem is exist unfortunatly.

here is my code:



WITH thisform.list1
.rowsourcetype=3
.RowSource = "SELECT Havaleh.vnum, Havaleh.vdate, Havaleh.vval, Havaleh.transpay,;
Owner.ofamily, Products.pname, Havaleh.ocode, Havaleh.pcode,;
Havaleh.tonkiloo;
FROM havaleh;
LEFT OUTER JOIN owner ON Havaleh.ocode = Owner.ocode ;
LEFT OUTER JOIN products ON Havaleh.pcode = Products.pcode ;
ORDER BY Havaleh.vnum INTO CURSOR CursorTemp"
.refresh
ENDWITH


but when i run my form an error message say that exist error in my SQL statment.
when i delete Havaleh.pcode,Havaleh.tonkiloo problem was solved.
i dont know is it because number of field is more than 8?