I have three action buttons on my form call then but1, but2 and but3. I want the same event to happen if the user pushes either of the three buttons. Is there a short hand method to write one set of code with an "or" type statement?
Advanced Beginner
Windows 7 64bit 
Access 2013
I have three action buttons on my form call then but1, but2 and but3. I want the same event to happen if the user pushes either of the three buttons. Is there a short hand method to write one set of code with an "or" type statement?
Very Inert Person
Windows 10 Access 2016
Hopefully these buttons are calling the same function, which then decides on what to do based on the button rather than simply running the same block of code.
Anyway, what I think you want to do is select all 3 in design mode and enter the name of the function in the click event property on the property sheet' e.g. =MyFunction(). Note that it has to be a function in a standard module. It cannot be a sub nor can it be a function on a form/report.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Who is John Galt?
Windows XP Access 2007
Create a form level function/sub and call it from each of the 3 buttons.
Key Press Event and/or Key Up Event not firing as expected
Subform listbox populate on load event AND form populate on Click event
Event Procedure for on load event for Form
Posting Permissions
Reply With Quote