i am using VB with access. i need to load the values of a particular field in a table to a listbox .
i used the following coding in the Form_Load event.
Set db = New Connection
db.Open "PROVIDER=Microsoft.Jet.OLEDB.3.51;" & "data source= " & App.Path & "\test.mdb;"
Set rs = New Recordset
rs.Open "select name,model_no,product_master.capacity from product_master,com_evap where com_evap.model=product_master.model_no", db, adOpenDynamic, adLockOptimistic
List1.DataSource = rs
For i = 0 To rs.RecordCount - 1
but i throws an error telling "method not found",and points to "list1.datasource "
then i removed that line and run the program . but then it didnt display anything in the list box.
can someone plz help me with this ?