Hi Evan,

Hmmm, the same reply in 6 seconds time...

Walter,



>>I have some classes that contain Listboxes and Comboboxes that use SELECT statements to obtain the lists.
>>
>>Whenever I use more than 1 class on a form, I would like it to SELECT into a unique cursorname to avoid any problems.
>>
>>So far, I've noticed you can't use SELECT INTO CURSOR (this.Name) as it errors, and I have tried writing a procedure called GetCursorName(), but it doesn't like that either.
>>
>>I know you can use PUBLIC variables to handle this, but I would rather not!
>
>To get around this I have added an array property to my combo class and in the init of the combo I SELECT somefields FROM somewhere WHERE something = thatthing INTO ARRAY THIS.cboArray . The rowsource is THIS.cboArray .
>
>This prevents having to create arrays and cursors with unique names. I would imagine that this can be used with listboxes as well.