The database attached here in zip file meep4.zip was deleted from the original thread. It was attached to post#50 originally (2011)
https://www.accessforums.net/showthr...hlight=keyword
The database is meepjed.mdb
You should review that that series of posts to understand the context of the original poster's (meep) problem/issue.
You will also see how during the course of these posts how the issue evolved and how the database developed.
In overview the OP had a number of barcoded medical reference texts, with Titles and details.
The problem/issue was to be able to retrieve records quickly based on Keywords and/or fragments within the Title.
In the Reserves Database form, you can select an output (Form, Print Preview, PRINT).
You can enter any number of keywords or fragments ( 1 or more characters) separated by one or more spaces.
There is an implicit AND between keywords and fragments. That is, records returned will be those with all keywords and fragments
that were entered in the Search Phrase.
There is a command button with a magnifying glass image. Click this to invoke the Keyword search.
The code behind the button will handle any number of terms/fragments as long as they are separated by one or more spaces.
The search will convert various different quotes found on some keyboards to the single quote/apostrophe (').
It will open another form (Found Titles) if there are Titles matching the search terms OR it will give a message that no Titles exist with all of those terms.
You could close the Found Titles form, then click a different button on your form to Preview a Report.
When looking at returned records in the Found Titles form, you can double click on the ItemBarcode to open another form
showing the details of the reference record.
Jpgs of various forms are attached.
There are 596 records in the database. The Titles contain 1448 distinct keywords.