ado data control

12-17-2003, 09:22 PM
Using ado data control in program.
data is the instance of that control.
I found out I could do this:

data.Recordset(2) = "two"
data.Recordset(2) = "more"
data.Recordset(3) = "power"
data.Recordset(4) = 3
data.Recordset(5) = 5

This adds items into my database

I can do this to read

debug.print data.recordset(3)

Unfortunately it only reads the last entry in a field, at least by default.
What do I do to read from other rows and columns in the data base?
P.S. Please don't suggest anything far more complicated like using an ADO class. I need to get this done really soon, and if this does what I want it to that's really good.

12-17-2003, 09:31 PM
use Requery here to refresh the data.

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum