Is there an easy way using VBA to create a search box, that looks for a specific field in a form?
I would like a button on a form that is linked to a macro to search under the particular field for a user-entered value.
I found a macro online, but it keeps giving me a data type mismatch. The field I'm searching under is formatted as short text, but the search text box will not allow me to change it to short text. It gives only number options. Thanks!