Expression on click error

[CHEECO]

Hello again



I have a calendar / appointment database that added to another database that I have. After moving all the forms and queries and so on to my data base I am getting the below error on many of the button for the calendar / appointment database.

[ranman256]

sounds like you defined something as string but used is as integer.
or tried to assign it as an object....

something like that.
try hitting CTL-break after the message, and see if it shows you.

[CHEECO]

No it does not show me. It just closes the error message. I never changed any code. I just used the external data to copy the files over and then it did not work anymore.

[ranman256]

these are the hardest to find.
somewhere in form load, or oncurrent, it is assinging something
check all the declarations and make sure they are the correct data types.

[davegri]

If you carefully read the error description it is saying that the name of the command button clicked does not match the name of the event procedure it is connected to.
For example, if the command button is named 'Next', the expected event procedure is named 'Next_Click()'.

[John_G]

One possibility is that although you moved your forms, queries etc to another database, you forgot to move a code module.

In the forms that are generating the errors, what are the settings for the On-Click event property? Do they refer to a function? If they do, did you transfer the code for the function to the new database?

[CHEECO]

Good advice from all. I will look into these suggestion and get back to you all.