>Hi,
> Do you know how to put all the table name into the combo box ?
> Because after use adbobject(), the tables name will store in an array right, but how to put all of the table name into the combo to let user select ?
> Thank you
>
>regard,
>kengwen

You could create a combobox class for this

Add 2 properties to it:

aTableArray(1,1)
cDatabaseName

In the Init, do

With this
  If !Empty(.cDatabaseName) And DBUsed(.cDatabaseName)
    Set Database To (.cDatabaseName)
    ADBObjects(.aTableArray, "Table")
    ASort(.aTableArray)
    .RowSourceType = 5
    .RowSource = "this.aTableArray"
  EndIf
EndWith

At design time, after you've dropped this control on a form, set the cDatabaseName property to the name of the database you want to use.