populating text box from sql db 1

[croakyfrog]

hi

what i'm trying to do is populate a txt box from a sql db. i don't want the box to have anything in when the user goes to it but i want it to come up with matching results as the user types in the word, ie if they type in w it will come up with a list of "what, where, welly", when they type in wh it will come up with "what and where" and when they type in wha it will just have "what" as the only word in the box.

if anyone understands this dodgy explaination could they explain how this would be done?

 

[croakyfrog]

ps. coudl it be done with a stored procedure?

 

[BobWman]

I would do something like this:

Private Sub txtSearch_Change()
Dim strSearch As String
Dim strSql As String
Dim rsTemp As ADODB.Recordset

strSearch = Trim$(txtSearch.Text)

If strSearch = vbNullString Then
Exit Sub
End If

Set rsTemp = New ADODB.Recordset

strSearch = strSearch & "%"
strSql = "select MyField from MyTable Where MyField Like '" & strSearch & "'" & " Order By MyField"

' Open the recordset using strSql and populate the text box from it. Clear the TextBox first. Add data like this:

txtOut = txtOut & !MyField & vbCrLf