I am programming in Access and there are over 60 text boxes all that start with txtTime_##. The program needs to set the value as the current time when clicked. It's fine and dandy to make 60+ txtTime_##_Click() txtTime_##.Value = Now. However, I believe there should be a less time consuming way to do this. There should be a general Click method that captures the clicking of the mouse, correct. Then find out the name of the component that was clicked and if the name has txtTime_ then place now inside of component name. I do not know how to accomplish the general case.
Thank you for any help.