Access 2007 and Filter on content

[MadMax71]

Hi all, i'm new to this forum, i would like to know if i can add a button (or event) to my form to invoke the "Text filters -> Contains" popup, to not require users to right-click on mask fields. This is a request of my customer, but i didn't find any solution to do this..

[PianoMan64]

Hi all, i'm new to this forum, i would like to know if i can add a button (or event) to my form to invoke the "Text filters -> Contains" popup, to not require users to right-click on mask fields. This is a request of my customer, but i didn't find any solution to do this..

The simplest way to deal with that issue is to create textfields at the top of the form. Have a ListControl that displays the data and then they can enter the values that they want to filter by and then click the search button.

If they insist on using the form filter option, there isn't any easy way to get around that at all.

This way you have some control over how the data is displayed, as well as have some options to edit the entries if they need to be able to do that.

Let me know if this is what you're wanting, if so, I do have code examples I can post.

Hope that helps,

Joe P.

p.s. just email me on here and I can send you those code examples.