adodc

what is it you want to do exactly? Can you give an example?

with adodc1
.recordset.close
.recordsource "select * from xxx where xxx = xxx
.recordset.open
end with
somthing like that.... I just dont know how to do it right

EXAMPLES:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmscadocodeexamplesinvisualbasic.asp

Here is a very simple example:
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset

Dim sSQL As String

   
    cn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source = " & App.Path & "\ado.mdb"
   
    With rs
        sSQL = "SELECT * FROM tbl1 WHERE fld1 = " & InputBox("Enter something ", "", "")
       
        .Open sSQL, cn
   
   
        Do Until .EOF
            Debug.Print "Field 1 =" & rs("fld1") & " SomeShit =" & rs("someshit")
            .MoveNext
           
        Loop
       
    End With
    rs.Close
    cn.Close
   
I can send you the database (Acces) and VB code if you like?

i dont know how it works with adodc control I pretty much a newbie too this thing

You should be able to set the recordsource, if this is what you mean!

datPrimaryRS.RecordSource = "select fld1,fld2 from tbl1 WHERE fld1 = 1"
datPrimaryRS.Refresh

what is datprimaryrs i only have a adodc control and a datagrid on my form

can you send me the application? If so, zipped to dktebrsa@europe.lego.com

I have completet now adodc1.recordsource = Text1.text
adodc1.refresh

thanks a lot can i ask you questions if i need some help another til...
Im happy it works and it it easy ..

I dont mind if its a short question, but you should go through eksperten, thats where the points are :o)
Also you may get a number of different answers which can also help learning!

Thanks :o)