Refresh Combo Box (Drop Down List) (1 Viewer)

[K0k1man]

Hi,

I have a combo box in which it's value changes according to user input. It is working but it is annoying to have to click the combo box for it's list to refresh. How to make it seemless?

Thank you

 

[rainman89]

put
me.comboboxname.refresh or requery if its based on a query
in the afterupdate of the txtbox for userinput

 

[K0k1man]

I have done so but the second combo box still displays the old value. I literally have to click on the combo box, scroll down and select the new values which populated but not deleted the previous selection

 

[rainman89]

the user enters text and the combo boxes are populated based on that? or you select something from the first combo and the entries go into the 2nd combo box?

 

[K0k1man]

The values from combobox1 selection triggers a query which populates combobox2. Every time the list gets updated but the old selection stays as first and selected option

 

[rainman89]

search cascading combo boxes.

 

[Tshorolpa]

the user enters text and the combo boxes are populated based on that? or you select something from the first combo and the entries go into the 2nd combo box?

Were you able to get solve this?

Scenario:

Combo1: Value1
Combo2: Value1a

Combo2 values is dependentant on Combo1.
After selecting above scenario, I want to change
Combo1 : Value2.
Combo2: Value2a.
As soon as I select Value2, I want combo2 value to be refresh.
This is not happening.
Only when I select the combo2 dropdown list, the value is refreshed.

Is it clear what I am trying to say?
This is not regarding Re-query. I have already used Re-query and two combo box are reflecting values fine.