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