Select case and command buttons

[thart21]

I'm wondering if it is possible to use a Select Case statement with command buttons. I have 5 command buttons to group supplier choices alphabetically (A-F, G-L, etc.) On_Click is set up to open a form filtered with a macro to show only those Suppliers in that alpha group. I'm thinking a Select Case would be cleaner but wasn't sure how that would work without it being a "group" i.e. option buttons. Is this possible?

Thanks,

Toni

 

[Oldsoftboss]

See if this is an alternative. An Alt shortcut can be created on an option group, cmdButton or to set the focus to a textbox.

Dave