Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 620
  • Last Modified:

ACCESS. openform action cancelled

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
dpalyca
Asked:
dpalyca
1 Solution
 
jadedataMS Access Systems CreatorCommented:
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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now