Access 2007 SQL txt field Question

I'm trying to understand how to extract data from a query using SQL to form.

Question: Can you assign a query value to a text field?  or does it always have to be a list box?

Me.txtCity.RowSource = vcatch  returns a value

Me.txtCity2.Value = vcatch returns the SQL statement.

Private Sub Command5_Click()
Dim db As DAO.Database
Dim rst As DAO.Recordset
Dim strSQL As String
Dim vcatch As String
Dim vsql As String


If IsNull(Me.txtsearch) = True Then
    MsgBox "Please entered a client ID", vbOKOnly
Exit Sub
Else

vsql = Me.txtsearch

strSQL = "SELECT Table1.City " & vbCrLf & _
"FROM Table1 " & vbCrLf & _
"GROUP BY Table1.CompnayID, Table1.City " & vbCrLf & _
"HAVING (((Table1.CompnayID)='" & vsql & "'));"




vcatch = strSQL

Me.txtCity.RowSource = vcatch
Me.txtCity2.Value = vcatch
Set db = CurrentDb
Set rst = db.OpenRecordset(strSQL, dbOpenDynaset)

If Not (rst.EOF And rst.BOF) Then
      'display your records
              '........................
Else ' if no records found
      MsgBox "No records found!", vbOKOnly

    Set rst = Nothing
    Set db = Nothing
    
End If
End If
End Sub

Select allOpen in new window