>I tried that way first but as i coudn't write long SQL statements in the
>ROWSOURCE I changed it to ALIAS and put that SQL statement into the init
>event of the form.
>
>Do You have any idea of putting long SQL statement in to the Poperty window of the listbox.
>
>Shashi
Shashi,
I never put directly in property sheet. Instead in init do like this :

cSQL = "select ...."+;
   ".."
this.rowsurcetype = SQL
this.rowsource=cSQL

Cetin