Solved: SQL and Textboxes

[icthus123]

I think this is probably an obvious question. But how to I populate i textbox with the results of an SQL Query rather than a combo box?

[Ebrow]

Sub test()

Dim mySQL As String
Dim rs As Recordset

mySQL = ""
mySQL = mySQL & "SELECT tblTest.TestField "
mySQL = mySQL & "FROM tblTest;"

Set rs = CurrentDb.OpenRecordset(mySQL)

textbox1.Value = rs![testfield]


End Sub

[icthus123]

Sub test()

Dim mySQL As String
Dim rs As Recordset

mySQL = ""
mySQL = mySQL & "SELECT tblTest.TestField "
mySQL = mySQL & "FROM tblTest;"

Set rs = CurrentDb.OpenRecordset(mySQL)

textbox1.Value = rs![testfield]


End Sub


Thanks a lot ebrow! Works fine!