>i build S.Q.L and insert the result to table.
>how can i load the data from the table to my DBList.
>or how to send the S.Q.L result to the DBList.?
What is DBList? If it's listbox then you set
List.Rowsource="yourtable"
List.Rowsourcetype=2
List.Requery
Edward Pikman
Independent Consultant