Change behavior of "Live Search" script
I have a "Live Search" script so that as the user types into the field at the top of the layout, the records automatically filter as they type. I have a screenshot of the script attached here. I got the script from http://filemakerinspirations.com/2009/10/live-as-you-type-search-in-filemaker/ It works perfectly when looking for text in the "AccountName" and "EventTitle" fields as shown. I would like this script to also search the "EventID" field. That Field will always be the letter E followed by five digits, such as: E05015 or E04138 (that is: E oh five oh one five and E oh four one three eight)
I did modify the script to include:
Set Field [ Events::EventID ; $thisTerm]
But when I attempt to search for any EventID, the script always breaks out (aborts) after I have typed the first two characters: E0
Can someone point out the flaw in the logic that is causing this? Thank you very much, I really appreciate your assistance.