Solved

ACCESS.   openform action cancelled

Posted on 2004-07-30
1
571 Views
Last Modified: 2008-02-01
I am getting an runtime error upon executing this code:
runtime error '2501'  The openform action was canceled.
This code worked initially so I am unsure what to think now.
Here is the code:
stLinkCriteria = "[productID]= '" & Me![Text27] & "' And [draft] = " & Me![draft]
stDocName = "frmwhy?"
DoCmd.OpenForm stDocName, , , stLinkCriteria
stDocName2 = "updatebuildrequest2"
DoCmd.OpenQuery stDocName2, acNormal, acEdit
DoCmd.Close acForm, "frmbuildrequestqueue"

The debugger mode shows the linkcriteria executed correctly.
0
Comment
Question by:dpalyca
1 Comment
 
LVL 32

Accepted Solution

by:
jadedata earned 125 total points
ID: 11681439
the error is coming from the form you are trying to open with this code, NOT in this code itself.  Probably a flaw in the forms OnOpen logic or in a data error caused at open.

-j-
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question