I've seen it done in Access 2000, but now I'm trying to do it in Access 2007 and it doesn't work. That would be very useful, for example, when a large group of buttons basically do the same thing, like in calendars for example.
Instead of using the Code Builder to generate a large number of Subs like these:
... I was able to simply write "=HandleButton("XY")" statements in the property sheet of their OnClick events. In Access 2007 I'm getting an error message "The expression you entered as the event property setting produced the following error: The expression you entered has a function name that Microsoft Access can't find.".