AlphaFilter Forms

I have been using this for some time now. It is a subform based on the alpha filter macro and removes the need for having multiple macros. It is a form whereby the only thing you need to do is on frmalpha... whereby you specify the frm and the field name you wish to filter on. remember to set the form to allow filters.

Simply add the frm alpha... as a subform on the main form and ensure that you set the field for finding on.

You should be able to work out what I did in this subform to cater for different forma and fields.

Update: 19 March 2010:

Modified the way the control is passed from the subform and used in the filter statements. Simply look at how the control event is passed to get an idea of how its is done. Updates welcome.
If you modify please repost for others to use.
Tonez90

hey, just had a look. nice. however, the "all" button has no effect on resetting the filter?

Can you please be a bit more specific. When you open the database there 31 records, Click D and you filter down to 2 records, press the All button and then there are 31 records.The fSetFilter procedure in the FrmAlphabetSelecor is only 6 lines have a look and see if there is a problem but it seems to work for me. Anyway I have since updated however the size is over 800k and cant be posted here. I added a search function. If you want it drop me an email.
Tony