the adodc1 delete my information form the database ??

[xray]

peace be with you

i make small project using ( adodc1 - combo1 - 2 text )

i make a connect between ( adodc1 & combo1 ) after "run" all the data in the database delete and be empty !!
i use this code for showing :

Private Sub Form_Load()
Do
Combo1.AddItem Adodc1.Recordset("name")
Adodc1.Recordset.MoveNext
Loop Until Adodc1.Recordset.EOF = True
End Sub

how i can make the ( adodc1 & combo1 ) show the data and not delete

thanks

[xray]

peace be with you

i test it by " combobox1 " and it's work so good !!

what's the different between the two ( combo1 - combobox 1 )

thanks

[xray]

peace be with you

after choose form combobox1 when i click over text the combbox cleared !!

thanks

[[email protected]]

you just need one more command (adodc1.refresh)

like this:

Private Sub Form_Load()
Do
Combo1.AddItem Adodc1.Recordset("name")
Adodc1.Recordset.MoveNext
Loop Until Adodc1.Recordset.EOF = True
adodc1.refresh
End Sub

[xray]

peace be with you

thanks [email protected]

[dglienna]

you have your email address visible again. the bots will be able to get it.
Just change your signature. We can link to your profile, so you should just leave it there.