ado data control

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


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

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?
Thanks,
qb45man
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.

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

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum