Eh... The next my bug...
This.RowSource="SELECT authcode,auth_sname,auth_fname,auth_mname FROM author WHERE authcode>5 INTO CURSOR "+This.Tag
...and table author must be openned.
MartinJ
>I hope this won't sound irritating.
>
>I am getting Syntex error on following statment
>
>This.RowSource="SELECT authcode,auth_sname,auth_fname,auth_mname FROM author WHERE authcode>5 INTO CURSOR"+This.Tag
>
>I have taken the following steps.
>
>1. I have copied the code into listbox init and destroy area as suggested by you.
>
>2. I have removed the Rowsource code from Property of listbox.
> Property window shows (none) for RowSource
>3. Property window of Listbox for Rowsourcetype still shows
> 3 - SQL Statement
>
>Where I am going wrong ? Pl. help.
>
>regards