VB gui in Access 2007 question:

[mrbeepa]

I am not really familiar with vb so know your not talking to the whiz kid here.
I have built a form in Access 2007 and have added some event procedures using the visual basic gui.

The problem I'm having is there is a wrongly label function or definition, bear with me, .... at the top of the window that opens when I go into vb mode are 2 drop down lists I am not sure what to call them. But in the one on the right there is a routine or function name, title whatever it is that is misspelled it is called rulerFilter. I have no idea how to access this item in the drop down list so I can get rid of it. I tried getting rid of all sub routines that were related to rulerFilter. The problem is I have a ton of other stuff that is labeled correctly, "RulerFilter" with the uppercaser R instead of the lower. But every time I go to write a sub and I use the uppercase R form of the name when I save it the program changes it to match the lower case rulerFilter. I believe it is matching the name in the list on the left of the window but I can't find how to get rid of any items in that list. Can someone tell me how that list is generated and maybe how I can get take something off the list. I have tried closing, in and out of the db and the form that are involved, checked everything I can think of without any luck? I don't see a way to upload a picture or I would.
I appreciate any help I can get with this.

I figured out that the list I'm lookin at is the object list and the other list is the procedure list. How can I get rid of an item on the object list?

 

[RuralGuy]

Have you done a Compact and Repair? Office Button>Manage

 

[mrbeepa]

Have you done a Compact and Repair? Office Button>Manage

No I haven't done that, but I will now that you have suggested to do so. :

 

[RuralGuy]

Let us know if that cures the issue.

 

[mrbeepa]

No that didn't cure it???

I have completely taken all routines built around the rulerFilter out of the code and "rulerFilter" is still in the object list. I have no such creature on my form or in my db tables? so how can I have an object that doesn't exist anywhere but in the vb code object list. No other vb code references this now?

 

[boblarson]

If you've removed all of it, then import everything into a brand new, blank MDB or ACCDB file. That usually will clear out things that seem to "get stuck" at times like this.

 

[mrbeepa]

If you've removed all of it, then import everything into a brand new, blank MDB or ACCDB file. That usually will clear out things that seem to "get stuck" at times like this.

I appreciate all the help, and I probably should do that to insure there are no further implications from the stuck data. But for the time being I succumbed to it's wishes and went through and changed the code to read "rulerFilter" instead of "RulerFilter"!

It is working but I like the idea you have about importing it all into a new db.

Thanks again, to everyone, for the time spent and the advice.