Runtime error 2467 Woes PLEASE HELP!!
Posted on 1999-07-15
I have a user that is doubting my system because of stupid runtime error 2467 (refers to object that does not exist) The error happens every second time certain forms are started.
I have code in the "On Current" event of main forms that triggers certain events in subforms. These triggers are neccesary...like text box locks, label visible etc.
For some reason the code runs before the subform opens (only every second time) The user closes the error window and opens the form. I can trap the error to be ignored I suppose but I am worried that I can end up with corrupted data.
The ideal solution would be to insure the subs always open before the code runs...how is this possible?
Or do you have another "easy" solution to this annoying problem? To me the Access Design Team should have this as built in functionality, but what do I know? :o/
The bottom line is why every second time? Seems Access changes the way it launches forms each time they open. A bug perhaps?
I DO have service pack release 2 installed so that doesn't help.