Creating a Keyword Search that filters records in a form

[Redbeard]

Hi All this is my first time post, be gentle.

I am looking at creating a keyword search that searches multiple fields in a Form and then filters records that match the keyword. The Form currently has a button that connects to a Query that run the keyword search in several field and then filters the results. The problem is that I can not do a search within a search, or have multiple words searched in any order. For example there are 20,000 records, I click the button and a Pop Up Box asks me to enter a keyword. I type "blue" as my keyword and it filters me down to 1,000 records. If I want to narrow it down farther I can't because if I click the button again it starts the search from my original 20,000 records. So I either need to be able to search for "blue" then re-search my filter records by "green" or to be able to search for "blue and green" in any order over the multiple fields. I have seen several codes posted in other posts that have elements of what I want this to do but I do not know enough about VB code to put it all together. None of them involved using a Query to do the search like I describe above (Which was built by my predecessor). I do not care if it is run off a Button that opens a Message Box or if it is linked to a Text box in the Footer Bar that you just type the keyword into and hit enter. I also do not care if it is built into a Query or just VB code. Also if the keyword in each record could be highlighted when it has filter the records that would be great as some of the fields are memo and there is a lot of text to look at the find the keyword.

Thanks

[nico5038]

Can you post the code the button is using ?

Nic;o)

[Redbeard]

Sure here is the code for the Keyword search button.

Private Sub Keyword_Search_Click()
On Error GoTo Err_Keyword_Search_Click
 
    Dim stLinkCriteria As String
 
    DoCmd.Close acForm, "frmDescription"
    DoCmd.OpenForm "frmDescription", , "qryKeyword3", stLinkCriteria
 
 
Exit_Keyword_Search_Click:
    Exit Sub
 
Err_Keyword_Search_Click:
    MsgBox Err.Description
    Resume Exit_Keyword_Search_Click
 
End Sub

[nico5038]

The query obviously holds a variable for filtering the records, causing the popup asking you the (single) value.
For multiple values you would need to have multiple fields on the form and construct a strCriteria with the entered values.

An easy solution is to use the right-click popup to perform the filtering for single selections or for multiple "AND" related selections, see my userinstruction for this at:
http://www.geocities.com/nico5038/xR...nstruction.zip
When you need an "OR" relation, then you can use the "Filter by Form" option allowing you to fill multiple "OR" tabs (see left bottom corner).

When you want to use the strCriteria filtering and start coding, then let me know.

Nic;o)