After Update Event run two functions

[nosaj03]

Hey all,

I need to run two functions during an After update event on a form. The two functions will operate individually but how to I write it to run one function after the other?

 

[plog]

Let's call the 2 functions you want to run Function1 and Function2. You simply call them both in the AfterUpdate event. Here's psuedo code:

Function Function1() As Variant

    dim ret as Variant    ' return value of this function

    Function1=ret

End Function1



Function Function2() As Variant

    dim ret as Variant    ' return value of this function

    Function2 = ret

End Function2



Private Sub inputName_AfterUpdate()

    f1val = Function1
    f2val = Function2

End Sub