>I have a listbox that I use to filter the contents of a grid. The listbox is populated using
>RowSourceType=3-SQL Statement
>RowSource = SELECT salesrepid FROM sales!salesreps INTO CURSOR tmpSalesId ORDER BY salesrepid
>
>I would like to add an "ALL" option to the listbox. How can I do this? Is there a better way of doing this than whats
>shown above?
>
>Thanks in advance for your help,
>Russell Clendenon

SELECT ' [All]' as 'salesrepid' ;
 FROM sales!salesreps ;
union ;
SELECT salesrepid ;
 FROM sales!salesreps ;
 INTO CURSOR tmpSalesId ;
 ORDER BY 1

Cetin