Filter and Sort using custom buttons

[ProwlingEyes]

I am using Microsoft Access 2010. It provides great filtering and sorting options in the ribbon for any object. But what if I hide the ribbon and want to create custom buttons on the form to do the filtering and sorting job? There are some filter options available in macros but are not quite like the ribbon's own Filter button. When the Filter button is clicked from the Robbin, a filter menu pops-up under the active field, which doesn't happen when I try to do it using Macro functions like "Apply Filter" or "Set Filter" etc. I want to have that big "FILTER" button from the Ribbon on my form. Am I missing something?

 

[CJ_London]

You can simply right click on a field and choose the filter options

 

[EternalMyrtle]

Your options are nearly limitless for creating custom filters using a combination of vba and queries (using buttons, dropdowns, option groups, text "search" boxes, etc) but it will take time, perseverance and creativity. Without more specifics, nobody can give you a concrete solution as there are so many ways to create search and filter functions in a form.