Combo box for recordset record

[NT100]

I've a list box of tutor and combo box in a form. The combo box is populated the qualifications by using DAO recordset in vba. When I click a list box, I want a particular tutor's qualification is highlighted/marked in that combo box and that selected qualification in the combo box scrolls up to the top of the combo box.

Is there any suggestion on this? Thank you in advance

 

[theDBguy]

Hi. Have you tried assigning the value to the combobox? The dropdown list only shows up if the combo has the focus.

 

[Deleted member 147267]

Sounds like a very odd approach. Mainly wondering why not just show the qualification in the same list box since it is only one field? Or put the qualification value in a textbox? It makes no sense to me to make Access programmatically "pick" a combo list value and display it in a combo - especially if it's bound. 3 clicks on different listbox rows and you've just edited a record 3 times.

 

[NT100]

Thank you for the advice.
This is my first time to use combo box in vba.

I did it now.

 

[theDBguy]

Hi. Glad to hear you got it sorted out. Micron and I were happy to assist. Good luck with your project.