I don't really understand what you wanna do, but thisform.text1.controlsource = lcSource.optwords could do a better job.

Include a thisform.text1.refresh, after you do this.


>lcSource = "SELECT optwords from smltbl ;
>WHERE smltbl.opttitle = 'APPR_CD' ;
>AND smltbl.optwords like 'REJ%' ;
>into cursor cSource"
>
>&&How can i show the result of the query in the text box
>&&I am doing this but nothing is happening.
>
>thisform.text1.value = lcSource
>
>&&I am looking for the property rowsourcetype of the text box.
>
>
>Thank you very much.