The search works, with problems. The code is below. (My text box is Text59, my table is called songs, and the search field is called title.)
Here are the problems:
1) I have to enter my search string in the search box with quotation marks, e.g. "God Bless America". How can I fix this so I don't need the quotation marks?
2) I would like to search by substring. I would like the search to retrieve the first matching record alphabetically. So if I am searching for "God Bless America" it might be all I have to type is "God Bless A" and it will go to the correct record. If I am not getting ahead of myself, could this mean it would search by a substring that is the length of the search string I entered? So some function like len(Text59) would return a value of that length (in this example 11) and then search the table with a substring of len?
Private Sub Text59_AfterUpdate()
'Find record based on contents of Text59.