What you describe should work.. try deleting the listbox and adding it again.. also check the columncount (try making it 2)
Or..
you can put the rowsourcetype as 3-SQL and put the SQL statement directly into the rowsource
But as I said, before you do any of this.. make an index on the table first.. this will give you a big performance improvement
>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
Will Jones