Orphaned Code

[Gordzilla]

Is there anyway of finding orphaned code behind forms and reports.

ie. Control was named txtDesc with various code attached to events.
Control was changed to a combo box and renamed to cboDesc.
All of the original code still refers to txtDesc.
I would like to be able to find any code that is no longered associated with
a control and either correct it or delete it.

 

[Stuart McCall]

Is there anyway of finding orphaned code behind forms and reports.

ie. Control was named txtDesc with various code attached to events.
Control was changed to a combo box and renamed to cboDesc.
All of the original code still refers to txtDesc.
I would like to be able to find any code that is no longered associated
with
a control and either correct it or delete it.

Open the form's class module, put the cursor in the declarations section (ie
before any procedures), and drop down the right hand combo. They'll all be
visible there.

 

[Klatuu]

Here is a link to a VBA editor add in that does that and a whole lot of other
neat stuff. Best part, it is free:

http://www.mztools.com/index.aspx

 

[Gordzilla]

Perfect exactly what I wanted.

Open the form's class module, put the cursor in the declarations section (ie
before any procedures), and drop down the right hand combo. They'll all be
visible there.