Unnecessary event procedure code related to forgotten deleted controls

[jarcanin]

I have written event procedures for several fields/controls in several forms of my Access 2003 db. I have subsequently delelted the fields.

I would like to remove the event procedures and code related to these fields that no longer exit.

Is there a way to find those procedures and code easily. I forget the names of the event procedures for these deleted fields/controls.

Help would be appreciated.

Thank you

 

[RuralGuy]

AFAIK the answer to your question is NO. You will have to hunt them down manually.

 

[boblarson]

You might get some help by going to DEBUG > COMPILE YourProjectNameHere in the VBA code window because if the code refers to the non-existent controls, fields, or forms, then it will throw an error. But, if they don't then you would have to hunt them down manually.

 

[mhartman]

Hello:

Please do the following:

1 Break into your code module and click in the top area of the code that contains the statement "Option Compare Database" or "Option Explicit"

2 Click on the "Declarations combo box and in the drop-down list you will see all the code for every control you deleted. Mere select the control and Access will move you to the code so that you can select it and delete it.

3 Repeate step 2 for each control

Regards
Mark

 

[jarcanin]

Thanks for responding and the direction.