>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
Hi,
How about setting the RowSource property in the Init of the Listbox/combo then Requery() it.
i.e.
LOCAL lcCursor
lcCursor = GetUniqName()
THIS.RowSource = "SELECT * FROM Table INTO CURSOR " + lcCursor
THIS.Requery()