I have a form called frmMainMenu (!).
It has 10 menu options which is basically calling other forms.
I want an Audit log - if possible by coding ONLY the frmMainMenu.
I.e. I want a line of VBA in the frmMainMenu which captures the option chosen from the menu.
The idea is that I get an audit like "UserA chose Menu Option xxxxx at 6pm". Under what "event" do I write this code??
I do NOT want to write the code in each of the 10 options - I want to write it just once - in the main menu