The Openform Action was canceled

[cgajendran]

Hi, I am support a application which was running for the past 4 years. This is completely developed by MS access and written in VBA.

Suddently the application is facing the above error at the following lines,

DoCmd.OpenForm FormName:="frmNewPeerGroup", View:=acNormal, windowmode:=acWindowNormal, OpenArgs:=5

Many instances this DoCmd.OpenForm command it giving the error in message box says,
_____________________________________________________________
The expression On Click you entered as the event property setting
produced the following error: The OpenForm action was cenceled.
* The expression may not result in the name of macro, the name of a
user-defined function, or [Event procedure].
* There may have been an error evaluating the function, event, or macro.
_____________________________________________________________

This is the error message i am receiving.

My problem is, the same code was running around 3 years, but suddenly some updates to microsoft or office updates might have changed this.
Could any one came across this error in the past weeks. Please let me know what else we can make this to work.

 

[RuralGuy]

What version of Access are you running. There are Service Packs for Office 2003 and 2007 and HotFixes to correct most of the errors caused by the SP's.

 

[cgajendran]

the application is developed and runs in Access 97. User are having access 97 runtime to run the application (mde file).
Can you tell me any recent updates to office will restrict to this functionality. any hotfix available to the same.

 

[gemma-the-husky]

this is often caused by something completely unrelated, but i think you have to look at the code.

i would step through the code, to see what it doesnt like - perhaps a key record has been deleted/modified etc

alternatively it may be a references issue.

 

[missinglinq]

If everything is being done in Access 97 I doubt that updates are the issue. In my experience this is almost always the result of some condition not being met, perhaps as gemma said, a key record being deleted/modified, or some such.

While Access is erroring out at the line

DoCmd.OpenForm FormName:="frmNewPeerGroup", View:=acNormal, windowmode:=acWindowNormal, OpenArgs:=5

in the calling form, the "OpenForm action was canceled" would indicate, to my mind, that the problem is actually occurring in frmNewPeerGroup. What is being done there in the Form_Open or Form_Load events with the OpenArgs? What significance does the have?