Bit of a newbie going through Peter Wright's Beginning VB6 book...

How come I can set an ADODC's properties with...

With Adodc1
.ConnectionString = "Provider= etc..."
.CommandType = adCmdTable
.RecordSource = "Titles"
End With

But I can't create a record set object from the above like:
Private m_recTitles as ADODB.Recordset (In General Declarations)
Set m_recTitles = Adodc1.Recordset (In Form1.Load())

And yet it works if I put the information in manually...?

Bit stumped, would love a pointer in the right direction...

Russ

__________________
Regards

Russ (Programing on L plates..!)

You need to use the data control's Refresh method after setting the control's properties at run time. After you execute the Refresh method, the (new) underlying Recordset will be available via the Recordset property.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

Jeff

I tried this:

With Adodc1
.ConnectionString = "Provider= etc..."
.CommandType = adCmdTable
.RecordSource = "Titles"
.Refresh
End With

But it still doesn't work. Am I doing this correctly? I've put the With statement in the Form1.Load() method as well, is that where it should be...?


Regards

Russ

Oops...

Having looked at it again I find that in fact I set the ADO properties via a Sub in a module, and yes, you've guessed it... I had the Set before the Call subADO()...

Lesson learnt: read your own code properly...

:-)


Regards

Russ