Hi i'm new in sql and vb...

I have a vb project with a *.mdb file where I'm trying to order data in the tables with input from a text box...

In my vb project I would like to have a text box where users can type a word and then order the data in the table.

I can do this without the text box like this
Data.recordsource = "SELECT Time, place, id FROM news ORDER BY xxxx"
Where the xxxx is where I would like the input from the text box..

Thanks :-))

Regards
Allan Bech