Dependent Combo box alphabetical order

[Zorkmid]

Hi there.

I have a cascading combo box based on a table of specific types of incidents.

So:

If you enter x into combobox A, you get list 1.
Enter y into combobox A, you get list 2 and so forth.

I want to update list 2, adding in a new selection. It is based on a table on the backend of my database. I entered the new selection there, and it does appear in my forms, but at the bottom of the list instead of alphabetically.

I have fixed this problem with non dependent combo boxes before, but I'm not sure how to solve this one.

-Z

 

[HiTechCoach]

What field are you using to sort the list?

 

[Zorkmid]

I don't understand that question, but I don;t think I can use rowsource, since that field is dependent on the previous combobox. Sorry if I'm a doofus.

 

[vbaInet]

I don't understand that question, but I don;t think I can use rowsource, since that field is dependent on the previous combobox. Sorry if I'm a doofus.

For example do you want to sort using Customer's Surname or Forename

 

[Zorkmid]

This list is in it's own table, and is only one field. Sorted alphabetically.

 

[vbaInet]

It's not a straightforward thing to do. You will need a sorting algorithm.

Unless someone has another idea?

 

[Zorkmid]

How did the list get in alphabetical order in the first place? Right now it's correct except this one entry. Could I just delete and remake it?

 

[dcb]

Change your table

tblList
=======
Incident
ListID

Thus

Pig | 1
john| 1
Fran| 2
Gret| 1
fras | 2

Combo Source would be :
Select Incident from tblList where ListID = 1 order by Incident;

 

[ChrisO]

Base the second combo box on a query and sort the table in that query.
You may then need to re-query the combo box after the entry of a new item.