How to populate data from db into data component?

[jcrtektip]

I am using access database. The following is the code used to connect to the database
'*********
strConn = "DRIVER={Microsoft Access Driver (*.mdb)};" & "DBQ=c:\XXXX.mdb;pwd=xxxx;"
Set conn = New ADODB.Connection
Set adors = New ADODB.Recordset
Set updateuser = New ADODB.Recordset
conn.Open (strConn)
Set adors.ActiveConnection = conn
'***********

How can I populate data from this 'adors' recordset into a data component?

Set Data1.Recordset = dbAccess.OpenRecordset("select * from table1")

 

[Forri]

You have to set the components binding to the adors

Datasource = adors
Datafield = Your Field


Nick

 

[jcrtektip]

This gives an error 'Invalid use of property'

I changed my code as follows...
set data1.datasource = adors

It says method not found

 

[Forri]

yes your rigt sorry!! i tought you were going to bind it at design time!

You should also set the datamember!