>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 did not follow the whole thread. But I've been told that if you have the ItemTip property set to .T. this could lead to the error you have. This is documented in the Microsoft KB. You might also do a search on "error 1152" and read the messages around the 20 of August. More details in there.

José