RecordSet

[Karina Gámez]

Hi

Im working with recordset on ADO ,.. and i want to fill a combo box with the results of this query..
Select TABLE_NAME
From information_schema.Tables
Where TABLE_TYPE='BASE TABLe'

Can anybody help me...

Thanks..! is urgent!!!!!!!

[Iouri]

First open recordset
sSQL = "select * from Table where ...."

rs.Open sSQL, connection, adOpenDynamic, adLockOptimistic

and now fill the combobox

Combo1.AddItem rs!FieldName

Iouri Boutchkine
iouri@hotsheet.com