Hi!

Just use fields, but with another alias:
RowSource = consList.cons_no,name

Anyway, see my other answer - listbox is slow with large number of rows...

>Hi
>
>If I use the sql statement as you have suggested then I have one doubt.
>
>I am putting sql statement in the load event
>
>Select cons_no, name from consumer where natur_code = "4" and !empty(ctaout_dt) and !empty(tvout_dt) into cursor consList
>
>How should I specify consList in the List Box ?
>If I give recordsource as consList and if I have RowsourceType as : 2- Alias then I don't get anything in the list box.
>
>
>Pl. Help.
>
>Thanks in Advance
>
>Ashish Patel