vb help with find code

[drowla01]

I am using VB6 and I am tryin to do a find where the user selects a market form acombo box and then clicks ona find button and inputs a bts they are trying to find. I want the db to search for the BTS only where the market they have chosen in the combo box is true any ideas? here is the code I have so far, it works as I have it with the 'before & switch. text4.text is the where the combo box value is stored.

Private Sub Command1_Click()
bos = Text4.Text
prompt$ = " enter the BTS"
searchstr$ = InputBox(prompt$, "bts")
test = searchstr$
Data1.Recordset.FindFirst "bts= '" & test & "'" '& "switch='" & bos & "'"
If Data1.Recordset.NoMatch Then Data1.Recordset.FindFirst "bts like'*" & test & "*'"
End Sub

thanks in advance for your help

[rustedtight]

clean up your english then we may understand your problem.

[detn8r]

quote:Originally posted by drowla01

I am using VB6 and I am tryin to do a find where the user selects a market form acombo box and then clicks ona find button and inputs a bts they are trying to find. I want the db to search for the BTS only where the market they have chosen in the combo box is true any ideas? here is the code I have so far, it works as I have it with the 'before & switch. text4.text is the where the combo box value is stored.

Private Sub Command1_Click()
bos = Text4.Text
prompt$ = " enter the BTS"
searchstr$ = InputBox(prompt$, "bts")
test = searchstr$
Data1.Recordset.FindFirst "bts= '" & test & "'" '& "switch='" & bos & "'"
If Data1.Recordset.NoMatch Then Data1.Recordset.FindFirst "bts like'*" & test & "*'"
End Sub

thanks in advance for your help

Use this:
Data1.RecordSet = "select * from YourTable where TBS=" & Searchstr