Hi

I'm sure this has been asked before but ....

I want to change the Adaodc control source RecordSource property at run time in a VB6 application

Is this possible? and how do I make it work?

I've tried


    adoContacts.RecordSource = strSQL
    adoContacts.Refresh

but this seems to disable to AdoDc control


Thanks
Psionman

__________________
Thanks
Psionman

Hi,

What you are doing is correct. The ADODC control will appear disabled if there are no records that meet your SQL statements criteria.

HTH

Byron

Thanks Byron,

I should know by now that what I think is the problem rarely is!

Thanks
Psionman