>how can i load table to DBLlist . ?
>or how can i send the S.Q.L result to DBList .?

You must use 2 data controls.
One for the "edit" portion and one for the "list" portion.

You have 5 properties to set:


DataSource Name of Data control that is updated once a selection is made.

DataField Name of a field that is updated in the Recordset specified by the DataSource property.

RowSource Name of Data control used as a source of items for the list portion of the control.

ListField Name of a field in the Recordset specified by RowSource that is used to fill the list. DBList does not support fields of LongBinary type for the ListField property.

BoundColumn Name of a field in the Recordset specified by RowSource that is passed back to the DataField once a selection is made. DBList does not support fields of LongBinary type for the BoundColumn.