It sounds like you already have what you need...just put it together.
If you want just the first three characters of a textbox you could use padright and substring like this:
TextBox1.Text.PadRight(3, " ").Substring(0, 3).Trim
This way even if the user only typed in single character your code will work.
Also, when you use the Like keyword you use % inside the string as a wildcard character. So you'd want to also add that to your string.
TextBox1.Text.PadRight(3, " ").Substring(0, 3).Trim & "%"
or to both the end and the start if you want any [dword] that contains the text instead of just starts with it.
If you want to order by something you just need to add the Order By clause at the end.
Order By [dwords]
See
this article[
^] for more info about Order By.
I'd also like to point out that your code is vulnerable to SQL injection attacks. You should be using parameters instead of text right from the textbox. You could start researching that with
google[
^].
Hope this helps.