[LogicTricks]

Hello guys , how can i update a combo box without closing it ?.. Ex: if i enter a number in textbox it will go to the database then automatically add to the combobox ..

How can i refresh it ?

If Index = 0 Then

query = "Insert into CAT(Category,Description)Values('" & Text2.Text & "','" & Text3.Text & "');"
rs6.Open query, cn, adOpenDynamic, adLockPessimistic
MsgBox "Category Saved!!!"
rs6.Requery             << ----------- I try this but it wont work
Text2.Text = ""
Text3.Text = ""

[tlhIn`toq]

Are you sure this is VB6 and not VB.NET?
Are you really doing this in a basically dead language that is only used for support of legacy applications?

[BobRodes]

So, same as in your other post, only more so. First, use a command object to insert your record. Then, open your recordset as a separate process. Then, tie it to your combobox.