>>I have a form with a multi-select listbox. I have tried every way I could find to get a list of people from a table into the list with no luck. I have tried using field, arrays, alias, sql statement, and cursor as record source and every time the listbox comes up empty when I run the form. I've looked at the example in Solutions but they are using values as the source. Any direction would be greatly appreciated on which source would be best in this situation and where and when I do each step. TIA!
>
>e pluribus unum:
>
>in the listbox init()
>
SELECT field1, field2 ;
> FROM mytable ;
> INTO CURSOR cuListSource
>
>this.RowSourceType = 2
>this.RowSource = "cuListSource"
>this.Requery()
Thanks, Trey, but it didn't work. I must be doing something weird somewhere but I sure can't figure it out. There's not a lot to check! When I bring up the debugger, I can see that my RowSourceType is set to 2 and RowSource is "cuListSource" but there is still nothing in the list box when I run it. I welcome any suggestions on what to check.