My database has several dozen records. Each has a unique identifier and a number of fields, including a Title field. I'm looking for a way for users to jump to a specific record from the home page. I've tried creating a search box to search for text strings in the Title field, with the following event procedure behind a button, but it only searches on the first word in the Title field. In other words, if I have a Title such as "My Best Access Practices" and I enter "Practices" in the search box, there are no results. I would have to search on "My" (useless, right?) in order to pull up this record.
This is what I'm using now behind the search button:
Private Sub cmdSearch_Click()
DoCmd.OpenForm "[frmName]", acNormal, , "[field name] like ' " & Me.txtSearch & " * ' "
End Sub
Is there an easy way to do this -- e.g., a query-based "directory"/datasheet for my home page showing all record Titles, and link those Titles to the actual record?
Thanks, Wizards.