>
> 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."
Matt McDonnell
...building a better mousetrap with moldy cheese...