I am trying to make a text box that acts similar to the find function in Access. I have made a macro that uses the find record feature. I want the user to enter what they want to search for (could be a name, or a number) in the text box (including searching with wildcards) and the macro should run and bring them to the (or closest) match. However, under the Find What option of the macro, I do not know what to type in. Is there a command I can use that will allow what the user inputs in the text box to be what would be used in the find what box to conduct the search? Any help would be greatly appreciated. Thanks in advance.
Enrico
Enrico
