"text begins with" filter

[aoswald]

I want a button or shortcut to use the "text begins with" filter on a form. How can I put such an icon or shortcut in my tool bar across the top?

thanks

 

[georgedwilkinson]

Seems like a lot of work for something that is already built in.

You know you can right click on a field on the form and type in your criteria in the "Filter" criteria. On version before 2007, you can just type in the text you want followed by a "*". On 2007, you can tell it that the text begins with and just type in your text.

Otherwise, you've got some coding to do.

 

[aoswald]

too many clicks

Yes I can right click on the field and then drill dow to "text begins with" but that is 3-4 steps. I want a shortcut

 

[georgedwilkinson]

Well, if you know which event of the text box will "trigger" the filter, you could just apply a filter to the form's result set in the event code.

 

[aoswald]

huh?

sorry - I don't understand what you mean