Thread: Displaying results of an SQL query in a Textbox

Hi All

I've got a form where I'm trying to display the results of an SQL query in a textbox by clicking a button. See code below that I'm trying but doesn't work, not geting an error messages the result just isn't displaying in Text51 when I Click the FindCommission_Ref button. The result I want is the Comissioning_Ref from the Comossioning table and will be got from 2 comboboxes(Combo27 & Combo31) where Commissioning.Doc_Ref = Commissioning.Vehicle_No

Private Sub FindCommission_Ref_Click()

  Dim strSQL As String
  strSQL = "SELECT Commissioning.Commission_Ref FROM Commissioning WHERE (((Commissioning.Doc_Ref)=[Forms]![Commissioning]![Combo27]) AND ((Commissioning.Vehicle_No)=[Forms]![Commissioning]![Combo31]));"
  DoCmd.RunSQL strSQL
  Me.Text51 = strSQL

End Sub

Any help would be much appreciated on this

Donal