Search box

[wolfm]

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!

[June7]

A textbox used to enter search criteria must be UNBOUND. Review http://allenbrowne.com/ser-62.html

[Missinglinq]

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.

So what are the Macro's Actions and Arguments? It sounds as if the Macro you found online was designed to search for a Numeric Field, and you want to search a Text Field...the syntax would be different for a Text Field.

Linq ;0)>