Hi everyone,
Let me see if I can answer everyone’s questions:
@Dunbarx - when I selected all the text that was in the text field, I wanted to be able to press the delete key (backspaceKey in LC) in order to clear the contents of the field. Adding the few lines of code Klaus suggested resolved that issue.
@FourthWorld - the list of customers will come my MIS/CRM software. The list currently contains 1435 customers.
I also made one additional change to the code:
Code: Select all
filter tList with ("*" & tLookupString & "*")
I added a * before the variable so that if I were looking for “The Acme Widget Company”, I can just type “Acme” and it would show in the list. Without the preceding *, I would have to type “The” to get it to appear in the list.
Now for the next challenge. Suppose the customer name field is populated but I need to add a word to it. For example, the field contains, “The Acme Company” but I need to add “Widget” in between “Acme” and “Company”. If I try to type “Widget” where indicated, because of how the code is written, the cursor keeps moving to the end of the field. I am aware I can fix this by updating the customer list field but that would require a re-compilation and deployment of the updated app. Although I may look into putting the list of customers into a text file on an internal network share and pull from that, any ideas on how to achieve this in the meantime?
Thank you again and best regards,
Jon
