> > I have a listbox given the user a choice of various inventory code to > select from. > > So, at first, we had a SQL like this > > SELECT NOCOULEE FROM COULEE GROUP BY 1 INTO CURSOR TEMP > > Then, we needed to add the choice of all inventory codes. > > So, because the listbox was using RowSourceType=3, I found a way to do it > while keeping that RowSourceType value. > > SELECT NOCOULEE FROM COULEE GROUP BY 1 UNION SELECT 'All' FROM EMPLOYE > > Note here that any table other than EMPLOYE will do the job. Is there any > other fancy way of doing that? Fancy? maybe not. But his is how I've done it before. Instead of RowsourceType = 3, set it to 5 and select into array. Then you can add as many array elements as you want in order to provide the user alternate choices other than what's in your table. HTH -- Matt McDonnell Conventional Wisdom - "If it ain't broke, don't fix it." Gates Wisdom - "If it doesn't work, sell it, and fix it later."