Add Item to top of Combo Box

[Sandman83]

Hi All,

I am trying to fill a Combo Box with a list of sites from a table. The table has two columns. Friendly Name and Tech Name. The first column is a name that the end user chooses and the second column is the technical name from another file. I want to populate the combo box with all the sites in the table in alphabetical order. That part is pretty easy, the part I am having trouble with is I want to add to the top of the list an entry that says "All Sites", above all the entries from the table.

 

[Remou]

Try this:
How to add 'ALL' to List Box or Combo Box.
faq701-2330

 

[Sandman83]

Thx Remou, but I had originally tried that and it doesn't put the "All Sites" entry at the top. I guess I could put "(All Sites)" instead and hope the end user doesn't choose a character that puts the end users entry up top.