Update and sort combo box values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how do i update and sort values in combo box after click on the combo? combo
is bound to a table
 
Bind the combo to a query instead of a table. The query will let you sort.

What are you wanting to update after selecting a value in the combo box? Do
you have two combo boxes and you're trying to filter the second one with the
first one?
 
Hi, Nermin.

I'm not sure I understand why you'd want to do it after clicking on it, but
you'd set the RowSource property and requery the combo box:

Me!MyComboBox.RowSource = "Select MyValueList From MyTable Order By SortField"
Me!MyComboBox.Requery

Hope that helps.
Sprinks
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sum combo box based on other combo box 2
cant get cbo to stop outputting key# 0
filter on combo box possible? 1
Access Form - Lock Fields from Editing 0
Refreshing tab control 2
Requery Form from Combo Box 3
Controlling a list box population based on combo boxes 1
Selection from combo box doesn't fill text box 2

Back
Top