Access VBA Me.Filter Property Question

[Jenaccess]

Hi,

I'm trying to set up a simple filter button in an access report. For example, my report might have 2000 services, and I don't want my users to have to go through them all to find the one they want. I wanted them to be able to narrow the results down by the first letter of the service.

I know that Access has a built in function for that, and all I'd have to do would be to right click in the field and plug in the letter. However, I don't want to make my users go looking for anything. I just want them to be able to plug the letter they want to search by in a text box, click a button that says "filter" and be able to pull up all the records that begin with the selected letter.

I thought this would be very simple, but I've been looking into it, and all the advice I seem to find is about plugging a Where Condition into the Open event of the report. This would not be suitable for me because I want to filter the report after it's already open. If anyone could suggest a solution I'd appreciate it. Thank you.

 

[John Big Booty]

The sample posted here might be of interest.

 

[Jenaccess]

Thank you John,

I looked at the sample database and it looks like a really useful tool. It's a bit above my skill level, but I'll be able practice until I completely understand. Would I be able to adapt the tool for a report rather than a form? Right now, I have 26 buttons on my report, all the letters of the alphabet, and users are able to click on the letter and go to all the records beginning with that letter. The sample you showed me is obviously more useful though because for some letters we have 32 pages of hits, and it would be much more practical to be able to narrow it down further. Again, thank you so much. I look forward to practicing.