Search two columns data in one text box

[oooppp]

vSearchString = SearchFor.Text

this will search all field data
but I need search column1 and column2 data only
Example column1 118 column2 22
text box entering only 118 22

Code using:
 
Private Sub SearchFor_Change()
 
'Create a string (text) variable
    Dim vSearchString As String
 
'Populate the string variable with the text entered in the Text Box SearchFor
    'vSearchString = SearchFor.Text & "*"
 
    vSearchString = SearchFor.Text
    ' vSearchString = "[PartNos] like " * " & txtBox & " * ""
 
    'vSearchString = Len(Me!txtName.Text & "") <> 0
    'btnNext.Enabled = Len(Me!txtName.Text & "") <> 0
 
 
'Pass the value contained in the string variable to the hidden text box SrchText,
'that is used as the sear4ch criteria for the Query QRY_SearchAll
    SrchText.Value = vSearchString
 
'Requery the List Box to show the latest results for the text entered in Text Box SearchFor
    Me.SearchResults.Requery
 
 
'Tests for a trailing space and exits the sub routine at this point
'so as to preserve the trailing space, which would be lost if focus was shifted from Text Box SearchFor
    If Len(Me.SrchText) <> 0 And InStr(Len(SrchText), SrchText, " ", vbTextCompare) Then
        Exit Sub
    End If
 
'Set the focus on the first item in the list box
    Me.SearchResults = Me.SearchResults.ItemData(1)
    Me.SearchResults.SetFocus
 
'Requery the form to refresh the content of any unbound text box that might be feeding off the record source of  the List Box
    DoCmd.Requery
 
'Returns the cursor to the the end of the text in Text Box SearchFor
    Me.SearchFor.SetFocus
 
    If Not IsNull(Len(Me.SearchFor)) Then
        Me.SearchFor.SelStart = Len(Me.SearchFor)
    End If
 
 
End Sub

[twinnyfo]

oooppp,

Welcome to Bytes.

First, please use the Code Tags when posting code to the forum, as this is a requirement of the site. this is the [CODE/] button in your post editor. I have edited your post above.

Second, I am not sure exactly what your question is. You seem to be explaining what your code does, but have not asked a specific question. If you clarify, we would be glad to assist you.

[oooppp]

I have text box called
SrchText
vSearchString = SearchFor.Text

I have Table1 field
ACnumber
PartNos

ACnumber 122
PartNos 28
etc..

I have to search this two numbers on SrchText
at present it shows all records when enter
instead 122 28

[oooppp]

I have to enter in that search box 122 which is in one column
and 28 is another column so it will show both columns data only instead of all data

at present when I enter 122 in that search box it will show all data

My search Criteria
Like "*" & [forms]![FRM_SearchMulti]![SrchText] & "*"

hope its clear

[twinnyfo]

Unfortunately it is still not clear.

I understand there may be a language barrier here--but I am still unclear what it is you want to do.

Try to be as specific as possible as to what you are looking for.

Thank you.

[NeoPa]

Hi Twinny.

They want to search across two separate fields (columns) by entering the two items of numeric data into a single string control. Such items being separated by a space.

@Oooppp.
Is there a good reason you want to work this way? Under normal circumstances one would expect to enter the two field values in two separate controls on a form. To do it with a single control simply makes it more awkward to use for the operator and adds more work for you to code.

Almost everything is possible, even what you ask for here, but that doesn't mean everything is a good idea. This is a very long way from a good idea.