Thank you for reply friends. Here I try to elaborate my problem
- Adodc1.Recordset.AddNew
-
-
TempH = InputBox("Enter New Item")
-
-
Adodc1.Recordset.Update
-
Adodc1.Refresh
-
-
Call RefHCompCombo 'POPULATES ITEMS FROM DB
-
Adodc1.Refresh
-
MsgBox "New Item Added Successfully."
New Item is being added successfully but
I want that newly added item as current selected item of combo box such that user should not have to again drop it down and select the newly added one.
Function which populates combo box causes combo box "Deselected"
In other cases I'm using Combo1.Text="ITEM NAME" and it works fine. But here it's not working.
Moreover even if it works -
1. Combo1.Text command just puts an string you want to display on combo box, it's not necessarily a combo box item.
2. Even If I give exact text as it's itemname would it behave like a selected item? means listindex property should give it's index by matching text.
I welcome any solutions/suggessions/mistakes/ideas
NE☼