string as an sql statement

[mrwigs]

hi, i have a string called myString that is an SQL statement. i am trying to run the sql statement as a query with the results appearing in a textbox.
if i put Text3 = myString then the textbox just displays the value of myString.

How do i get the SQL statment to run and then display the results in the textbox.

thanks in advance
adam

 

[KDg]

Hi Adam,

unfortunately it's all a bit more complicated than that. Are you on 2k or 97?

 

[shacket]

You want to set the string to the text box Control Source.

Me.Text3.RowSource = myString