Textbox - Onclick

I have a form which has unbound text fields and in another and in that form I have a sub-form that I have sub-Query. In the main form I also have command button. I want query data using the value that user enter in the text box and by clicking the command button. I tried so many way but I cant get button to recognize the data in the text box.(The data in the textbox relate to a field in a the subquery). Any help on this will be greatly appreciate. (I am new to VBA stuff, so sorry if this question is too low for this forum)

Be more specific, is it a VB application or a VBA application?
Post some code.

Private Sub cmdButton_Click()
'Dim strSQL As String
'Dim strSearch As String
strSearch = Nz(Me.prefixText, "")
strSQL = "select * from gisadm.gndlinefacilitymaintpole where((prefix)=" & strSearch & ");"
Form("MainFormWithCode").Form("QueryForm-updateIntHelp").RecordSource = strSQ
End Sub

This is a VBA application, and this is what i did..

thanks