Originally Posted by
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.
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)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007