From: jprobb@seniortrans.com   
      
   Yes... using a DAO Recordset and setting it to a DAO Recordset.  I can just   
   define it as a "Recordset" rather than a "DAO.Recordset" and get the same   
   thing.  The control on the other form has a recordset "DAO.Recordset" and it   
   is set to the control and works fine.   
      
   "Geoff"  wrote in message   
   news:454400e2$0$21350$db0fefd9@news.zen.co.uk...   
   >   
   > "Henning"  wrote in message   
   > news:4543d3da$0$32153$57c3e1d3@news3.bahnhof.se...   
   >>   
   >> "Joe-Paul Robb, Jr."  skrev i meddelandet   
   >> news:71u0h.51$mX4.14@trndny03...   
   >> > Hello:   
   >> >   
   >> > I am building a program in Visual Basic 6.0.  (Op Sys:  Windows XP 2002   
   >> > Service Pack 2)   
   >> >   
   >> > I placed an AOD Data Control on a form...and a data Grid.  I bound the   
   >> data   
   >> > grid to the data control.  Then used the following code to populate the   
   >> data   
   >> > control ...and thus, the grid:   
   >> >   
   >> >     With datPos   
   >> >         .ConnectionString = stConn   
   >> >         .RecordSource = sPosSQL   
   >> >         .Refresh   
   >> >     End With   
   >> >   
   >> > stConn is the connection string   
   >> > sPosSQL is the SQL Statement   
   >> > Then I refresh the data control   
   >> >   
   >> > I used the exact same language on a different form it the same   
   >> program...and   
   >> > it works fine.  I put it on this new form and I get the following   
   >> > error:   
   >> >      [ADODC]: Unknown error. [ADO];   
   >> > Press "OK" and I get:   
   >> >     Run-time error '-2147467259 (80004005)'"   
   >> >     Method 'Refresh' of object "IAdodc' failed   
   >> >   
   >> > To check out my SQL and be sure there was no error. I defined a   
   >> > DAO.Recordset. and opened the recordset using set MyRST =   
   >> > SUDB.OpenRecordset(sPosSQL) and  it opens... etc.   
   >> >   
   >> > Does anyone have any idea why I'm getting that "unknown" error with the   
   >> > program works elsewhere.   
   >> >   
   >> > Thanks...   
   >> >   
   >> > JP   
   >> >   
   >> >   
   >> If the ADO control is on another Form, are you referencing the control on   
   >> the correct path (Form)?   
   >>   
   >> /Henning   
   >>   
   > DAO.Recordset with ADO control ?   
   >   
   >   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)