Select all the frame and update (1 Viewer)

Onlylonely

Registered User.
Local time
Today, 08:48
Joined
Jan 18, 2017
Messages
43
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

Super Moderator
Staff member
Local time
Today, 01:48
Joined
Feb 19, 2013
Messages
16,603
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])
 

Users who are viewing this thread

Top Bottom