>I sure wish there was a simple way to give a listbox a SQL statement and have it own the data. I do not need or want the cursor it creates.
In the Init of your ListBox:
this.AddProperty("aList[1]")
this.RowSourceType = 3
this.RowSource = "SELECT * FROM yourtable INTO ARRAY this.aList"