cleaning up extra code?

[Guest]

hey all, i've noticed in my vb code, usually if i rename/delete a
button/control that has code behind it, the old code will remain behind under
the old name of the control. is there a feature in access that will go
through and remove any code leftover from a rename or deletion? thanx

 

[Allen Browne]

Access doesn't remove this for you, but it's not too hard to identify.

Open the form's module.
Move the cursor to the top of the module.
(You should have Option Explicit there.)
There are 2 combo's immediately below the toolbar.
The right-hand one reads Declarations.
It contains the list of procedures that are not tied to an object.

(You must have the cursor at the top of the module for this to be so.)