I'm looking for advice on how to go about creating and encoding a filter by form buttons on my Access 2007 main form.
I want the command button to change my form to look like it does when I use the toolbar's Filter By Form option and a command button that performs the same action as Apply Filter/Sort.
To summarize: I want buttons on my form that do the same things as the options on the toolbar.
I'm new to coding but would like to do this myself, more or less. I haven't found much stuff online that wasn't about advanced stuff like ADO and DAO programming.
Any thoughts, tips, insights or helpful suggestions, out there ot help me on my way?
Is this best suited for macros?