************************************************** *-- Form: form1 (c:\z\formlist.scx) *-- ParentClass: form *-- BaseClass: form *-- Time Stamp: 03/30/04 02:11:00 PM * DEFINE CLASS form1 AS form DoCreate = .T. Caption = "Form1" Name = "Form1" DIMENSION aarray[1] ADD OBJECT list1 AS listbox WITH ; RowSourceType = 5, ; RowSource = "thisform.aarray", ; Height = 133, ; Left = 48, ; Top = 36, ; Width = 145, ; Name = "List1" ADD OBJECT command1 AS commandbutton WITH ; Top = 60, ; Left = 240, ; Height = 27, ; Width = 84, ; Caption = "Command1", ; Name = "Command1" PROCEDURE Init * initialize the array element so it will show as empty thisform.aarray(1) = "" ENDPROC PROCEDURE command1.Click * substitute with your table here select name from mytable into array thisform.aarray thisform.list1.requery() thisform.list1.refresh() ENDPROC ENDDEFINEI guess you have the reasons not to use the SQL Select directly as RowSourceType, right?