Item not found in collection

[dp]

Hi everyone:

After years of using VBA, Im really getting sick of the basic "Item not
found in collection ", when coding recordset collections. Is there any way
to build a better mouse trap to detect which "item' it is referring to.
Sometimes, I have to use resume on next and in this case its hard to detect
which item it is when you have functions calling each other.

sincerely,
David

 

[Douglas J Steele]

Single-step through the code, and see which line raises the error.