Using VB5 Ent., I have written a program using a number of controls (bound & unbound). I've tried updating to VB6 Ent. using ADODC. I have a DBCombo bound to a DAO control to load the contents into the list, which works fine with ADODC. The problem is that I load a DB Grid with a second ADO data control using the bound text from the DBCombo. When I try to assign the grid using sql on the second control without specifying a recordsource, I get an error stating same. I can't use sql in the properties of the ADODC because it is reliant on the bound column of the DBCombo.
Any ideas would be great.