Kevin,

To avoid this problem, i've added an array (aSource[1,0]) property to both my combobox classes as my listboxclasses. In the Init I do a SELECT ... FROM ... INTO Array THIS.ASource.

Then you can set your rowsourcetype to 5 and your rowsource to THIS.Asource. I've discovered that this will also reduce performance problems with larger cursors.

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!
>
>Any ideas?
>Thanks
>Kev