Event procedure on Form level

[StefanL]

Hi ! I have a form with 160 controls in it. I want to trigg an event procedure when a control is clicked (don't matter which). Is it possible to do that on Form level and not Control level (i.e. without specifying an event procedure for every control) ?

Normally you specify Sub <Control name>_Click. But in that way i have to specify 160 such procedure if i want to cover all possible clicks.

I use Access 2000.

Nice if one of you has a solution
/Stefan

 

[Rich]

160 controls sounds like a serious design flaw, what's the logic behind having that many?

 

[ChrisO]

G’day Stefan and welcome to the site.

Here’s a little demo of a 300-seat display that should do what you require.

It was obviously written for another purpose but should give you the idea.

You may also need to create a reference to Microsoft DAO 3.6 Object Library.

Hope that helps.

Regards,
Chris.