This is a sample showing the use of "All" in a combobox. The application is quite simple and is meant for demo only. There is a list of Jobs and their corresponding starting salary (fictitious data). The combo lists each of the JobNames, and has
an All selection,
an All DB selection and
an All Programmer selection option.
Based on the selection, the results are displayed in a listbox on the form.
If you look at the Rowsource of the combo, you'll see how the All, All DB and All Programmer choices are created.
If you look at the afterUpdate event of the combo you can see how each of the ALL selections is processed.
Hope it's useful.