[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

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

Unable to open a access form

While I try to open a form using a command buttom it shows following message "You canceled the previous operation" and could not open the form.
Please advice what to do.

Thanks
0
alam747
Asked:
alam747
  • 4
  • 3
  • 2
  • +2
1 Solution
 
JezWaltersCommented:
I'm afraid you haven't given much information to go on, but is it possible that the "On Open" event handler of the form you are trying to open is cancelling the opening of the form?

You'll have to post a sample database if you want this debugged!  :-)
0
 
Simon BallCommented:
whats the code of the command button?
0
 
Gerwin Jansen, EE MVETopic Advisor Commented:
Does your OnClick property contain something like DoCmd.OpenForm "FormName"?

Post some code :)
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
JezWaltersCommented:
You need to post the code that is executed when you click your command button and the code that is executed when the form opens ...
0
 
hnasrCommented:
Attach a sample database demonstrating the issue.
0
 
alam747Author Commented:
Below are the code on click event...
Private Sub Command50_Click()
On Error GoTo Err_Command50_Click

    Dim stDocName As String
    Dim stLinkCriteria As String

    stDocName = "Debit Memo Data Input"
    DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_Command50_Click:
    Exit Sub

Err_Command50_Click:
    MsgBox Err.Description
    Resume Exit_Command50_Click
End Sub
0
 
hnasrCommented:
Create a new form, and apply the code to open this new form.
This is to rule out a corrupted form.
0
 
JezWaltersCommented:
What code is executing when you open your "Debit Memo Data Input" form?
0
 
alam747Author Commented:
I had a backup of the form before it happend therefore decided to use that one instead.
Thanks for your advice
0
 
alam747Author Commented:
Used the backup db to resolve the issue
0
 
alam747Author Commented:
Used the backup db to resolv this issue
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

  • 4
  • 3
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now