Select all the frame and update

[Onlylonely]

Hi Guys,

I have roughly 20frames in my forms.
Any idea how to select all the 20frames in shot and update?

Like ....

Private Sub All20frames_AfterUpdate()

coding....

End Sub

 

[CJ_London]

assuming coding is identical for each control, create a public function in a module for the code.

Then on your form, select all the frames and in the properties window (events) put

=nameoffunction()

against the after update event (where you would normally see [Event Procedure])