Select Hesab01 SET FILTER TO GCode = thisform.y_GCode .AND. !EMPTY(KCode) .AND. EMPTY(MCode) thisform.list2.ControlSource = "Hesab01" thisform.list2.RowSource = "KName"i get not correct filtered records, but if i change it as below
Select Hesab01 filterStr = "SET FILTER TO GCode = " + ALLTRIM(STR(thisform.y_GCode)) + ; " .AND. !EMPTY(KCode) .AND. EMPTY(MCode)" &FilterStr thisform.list2.ControlSource = "Hesab01" thisform.list2.RowSource = "KName"my list2 filled with right records. i know it is because of GCode = thisform.y_GCode , but why it is wrong?