error message while running procedures

[thepope77]

Hello everyone:

I am having major trouble with the code in one of my forms. I am getting an error ("Procedure declaration does not match description of event or procedure having the same name.&quot when I try to run any of my code. This just started happening seemingly out of the blue. Even if I just use the wizard to create a command button that adds a new record, I still get the same message. This is only happening on the one form.

If anyone can help it would be greatly appreciated.

Thanks so much.

 

[willir]

thepope77

Did the wizard create two modules? For example, "RefreshOnClick()". I get something like this when I delete a command button or combo box from the form and then recreate it later using the same name. I learned that I have to delete the code and then delete the object.

 

[thepope77]

No. It is giving that error message for some other objects that I know I haven't changed. Anything that has code is not working; just on this one form though. The other forms in the database are functioning just fine. I am very frustrated. Thanks for your help.

 

[willir]

thepope77

Do you use...
Option Explicit

Also, check out a Micrsoft bug alerts and KBase for VB, ActiveX and ADO...

http://support.microsoft.com/defaul...port/kb/articles/Q190/0/79.asp&NoWebContent=1

http://support.microsoft.com/defaul...port/kb/articles/Q193/3/26.asp&NoWebContent=1

http://support.microsoft.com/default.aspx?scid=kb;EN-US;222145

http://dbforums.com/arch/191/2002/5/388035

If any of these discribes your problem, then you may have to upgrade ADO or change a data type.

If not, I would try to isolate the problem by commenting out code or stepping through the code.

Richard

 

[thepope77]

willir:

Yes. I have the option explicit required in the options menu.

I just decided to re-create the form. The new form is working as it should. I have no idea what happened to the other form. Should I get delete the old form or do you think whatever caused the problem is contained within that particular form?

I really appreciate your help with this.

Daniel