Call Same Function for multiple controls

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a function that generates a SQL statement based on selections
(checkboxes) the user makes on the form. I want to have that function be
called whenever any of the checkboxes are changed (afterupdate event).

I know that I can create 23 different AfterUpdate event Subs, one for each
check box, and add the line to call the funciton to each sub.

What I don't know is if I can set that function as the AfterUpdate in the
control properties. So I don't have 4-5 lines of code nearly duplicated 23
times.

For example, if I somehow was able to have the function as a macro, I could
select that same macro for all 23 checkboxes without any additional macros or
coding.

Can I select that same function for all 23 checkboxes?
 
Can said:
I have a function that generates a SQL statement based on selections
(checkboxes) the user makes on the form. I want to have that function be
called whenever any of the checkboxes are changed (afterupdate event).

I know that I can create 23 different AfterUpdate event Subs, one for each
check box, and add the line to call the funciton to each sub.

What I don't know is if I can set that function as the AfterUpdate in the
control properties. So I don't have 4-5 lines of code nearly duplicated 23
times.

For example, if I somehow was able to have the function as a macro, I could
select that same macro for all 23 checkboxes without any additional macros or
coding.

Can I select that same function for all 23 checkboxes?
Click to expand...


Yes. Set the AfterUpdate property using this kind of
syntax:

=yourfunction(...)
 
When you have a function

Function YourFunctionName()
' Your code
End Function

In the AfterUpdate event you can write
=YourFunctionName()

Similar to the macro
 
Perfect. Thanks to both of you.

Ofer Cohen said:
When you have a function

Function YourFunctionName()
' Your code
End Function

In the AfterUpdate event you can write
=YourFunctionName()

Similar to the macro
Click to expand...
 
Back
Top