I have a guest list table. From that table I created a form. I want to add a button for each letter of the alphabet so that I can quickly retrieve all customers with last names beginning with the corresponding button. I know I have to write a macro but I can't remember how and then when I add the button have it's function open the macro. Am I on the right track? If so, please help me write the macro. I think there's a sample in the Northwinds database but I don't have it. Thanks.

Create a filter, then go to Macros and create a new one. On "Actions", choose "Apply Filter" and pick the filter you made. Then just link this to the button. Alternatively you can use SQL to get the same result, depending on what you are most comfortable with. Hope this helps.

Thank you very much - it worked!