Add additional Item to comboBox 1

[Fubear]

I have a form which contains a combobox and a listbox.

The listbox contains a number of items based on the ID number of the parent form.

I want the combobox to filter the listbox based on the category of the listbox items.

The listbox and combobox display their data correctly, and the filtering itself works fine. My problem is that after filtering the data, I can't then go back to view the whle list, as there is no "All" option in the combobox.

How can I add the "All" option to the combobox, and have it appear as the first item in the list while keeping all the other values sorted alphabetically?

 

[Savil]

Look at example one on this page

http://www.blueclaw-db.com/database_consulting.htm

Good Luck

 

[Fubear]

Thanks - perfect