There may have been an error evaluating the function

[valley]

Creating a new form by copying and renaming an existing form gives error

Hello,

Hello I keep getting the error after I copied a form
and saved under a different Name
++++++++++++++++++++
A problem occured while Microsoft Access was communicating with OLE Server
or ActiveX control.

There may have been an error evaluating the function , event or Macro

+++++++++++++++++++++++++
Strangely, I keep getting this error when loading
and clicking on a control in the ORIGINAL form
while the copy seems to work without errors.

I have deleted some tex box controls from the first
form and added a few new ones in the copy.

I have tried a copy of the database by deleting the
New form, but still get the same error.

I have run DEBUG on both form codes and
everything seems fine.

I have checked the refrences and find none missing.

Is there any way to resolve this issue. Or am I doing
something fundamentally wrong by copying
and modifying the form ?

I have attached the file with the two forms

 

[MStCyr]

Hello

As a quick test, I tried to debug both forms and both failed on Combo116. You may want to review this.

Best regards

Maurice

 

[valley]

Many thanks for your reply.
Combo116 is redundant as many others.
Only Combo 114 has two events attached to it.

Upon searching various things, I discovered that
the problem perhaps is with the the ON Click code
of the NEW RECORD button which is the only button
in the form and the main difference between the two forms (One with the button not working and the other without working)
Haviong said that I have a previous version of the DB with a incomplete form with the button which works as well.

Could you please help to see what is wrong with the button code ?

Many thanks in advance