Search By Keyword

[MG101]

Hi All,

I currently have a database with a few search forms. I recently attempted to add a box on one of my search forms to search 3 cells of a record for a key word. What happens is when I go to search, say for P0442, it does not bring up all of the records that contain that keyword in the 3 cells I have outlined. If I step down the code in the OR boxes of the query, it seems to work better but then for some reason my other search criteria , (Tracking number etc) does not work. I will upload the database for reference. I am currently working on the Search(View Only) and that is where you will find the query to work on. All help is much appreciated!

Thanks!

MG101

 

[JHB]

Give some example what you want to get, (and in which control you are typing in the values).

 

[MG101]

On the Search(ViewOnly) form I have 5 search criteria. Trracking Number, Date Code, VIN, Part Number, and Keyword or Phrase. Before adding the Keyword phrase to the search query everything works fine. I want the Keyword box to search in 3 cells of each record: Remarks, Additional Remarks, and Test Details. For Example: If I want to serach all records for "P0442" I could type that in the Keyword Search Box and it would find all records containing "P0442" in those three cells (Remarks, Additional Remarks, and Test Detail)

Thanks!

 

[JHB]

Try it now.
I saw you are requiring on a controls change event, it doesn't function because the "new" value isn't available, before the control has updated.