>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