Error message: The expression On Open you entered as the event property setting produced the follow

[Jerry Call]

If you examine my database I sent you earlier you'll see I have four basic forms for entering Catalogue data:
frmCoffeeCatalogue, frmSuppliesCatalogue, frmSodaCatalogue, and frmSnacksCatalogue.

I began with the Coffee Catalogue form and set up some basic code in it which works perfectly
as far as it goes. However, since I needed to add number of other features I decided to leave
Coffee as it was but clone it under the name frmSodaCatalogue. In the latter I have added
many, many new things. Many of them work fine, but to my amazement I find I get one
error message (the one above) whenever the On Open event runs.

Now the code for On Open is very simple. If you look at it in frmCoffeeCatalogue you'll
see that all it does is set the width of the form.

I have exactly the same code at the same place in frmSodaCatalogue. However, it throws
the error. I'm having trouble making any sense of Microsoft's cryptic error messages,
and this one has me by the throat.

Here's the whole thing (wasn't able to get it all in above): "The expression On Open
you entered as the event property setting produced the following error: Procedure
declaration does not match description of event or procedure having the same name."

I certainly can't find a singe additional reference to the On Open code anywhere in
any of my other code in frmSodaCatalogue. There is no "other procedure having
the same name" anywhere in frmSodaCatalogue. Just the form's On Open event
which sets width.

Up until recently this code worked fine in my enhanced frmSodaCatalogue. I'm
trying to figure out what could have changed.

Maybe I'll have to send you an updated database version so you can compare
the On Open code of frmCoffeeCatalogue with frmSodaCatalogue. But before
I do that I thought I'd see if somebody there has a bright idea what could be causing
the problem off the bat. In plain English, what is this bloody error message


telling us??

[June7]

I opened form in your db and don't get any error. So if there are changes after that version, need to see code.

[ranman256]

Did you check the vb references? Alt-F11, tools , references. See if anything checked is marked MISSING.

also, sometimes a control on the form has an incorrect setting.

[Jerry Call]

Well, I checked the dependencies area. Under Objects that I depend on I find, under "Tables," there are two items. One is tblSoda, and that's what I expect.
The other (aha!) is "MISSING frmSodaCatalogue."

But how can frmSodaCatalogue be missing? I can see frmSodaCatalogue in front of me in the Navigation screen, although it throws the error if you try to open it.
I did clone it a little while ago and then renamed it to the correct name. Maybe that's where the trouble occurred. But how to fix what's wrong?

[orange]

Can you post a copy of the latest version of your database? Zip format.

[Jerry Call]

Give me a couple more days and I'll send you the current version of my database.
Right now I'm attempting to reconstruct frmSodaCatalogue from a cloned version
of frmCoffeeCatalogue. So far Soda is coming up and working OK as I had new
features, but there will be quite a few more things in Soda than in Coffee because
I'm not going to clone the remaining three incomplete forms until I've got Soda
so that it's ready to run.

So for now go ahead and close out this string. But as Arnold Schwarzenegger
says: "I'll be back!"