Avatar of pcalabria
pcalabria
Flag for United States of America asked on

Need help syncing event procedures after controls are moved to tabs.

Hello Experts,

I'm using MS Access 2000 Sp1.  I don't know if this is a but specific to this older version, but this problems does exist with this version.

I create a form using text boxes, combo boxes etc, which have code in various event procedures (ongotfocus, afterupdate, onchange, etc)

Later, decide to use the tab control, so I create a tab.

I copy the controls originally created (before the tab was inserted), and paste the controls onto one tab.

At this point, everything appears to paste correctly, although none of the events work.

To fix an after update event, I need to go to the process that I would to create an event, and then PRESTO... the original event is now accessible.. so I simple close and the problem seems solved.

In my case however, I've pasted about 30 controls, and I can't remember which controls use events, and which events they use.

Since the events are still in the code, it seems like there should be an easy what to have the new tab control, link up with them.

Is there?
Microsoft Access

Avatar of undefined
Last Comment
pcalabria

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Gustav Brock

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
pcalabria

ASKER
Thanks Gustav!
Great to have an easy solution once in a while!
I imagine this is an Access 2K bug that was fixed in later versions?

I'll give it a try as soon as my "real long timeout expired" process completes...
I will be tonight.

PC
pcalabria

ASKER
Great solutions!
Thanks
Gustav Brock

No, it is "by design" and seems not to be regarded as a bug since it lives on in A2013.

/gustav
Your help has saved me hundreds of hours of internet surfing.
fblack61
pcalabria

ASKER
Thanks again!