>hi,
>i try t change but still the same.
>(my_char3 = thisform.combo1.value)
>
>
select sys(2015) as SortOrder,* from (ThisForm.Text2.Value) ;

There should not be a semicolon at the end. But anyway, it's hard to debug the problem for you when you show so much code. Try to verify statement by statement until you find, which one is giving you a problem (incorrect behavior). Then post just this statement back, if you need more assistance.