OpenForm action canceled

G

Guest

Can anyone help? I'm new to Access.......

I created a subform within a form. The main form had a button which took the user to yet another form and this worked fine. Then I moved the button to the subform rather than the main form. I amended the code to point at all the right forms but now when I click the button I get this message

"The OpenForm action was canceled

What am I doing wrong
 
G

Gerald Stanley

Without seeing any of the code, it is hard to be sure, but
a couple of things I recommend that you try. Firstly,
compile the entire database (From within the VB Editor,
look for Compile under the Debug menu). Sometimes, if a
form fails to compile 'on the fly', you can get this
message. Once the database does compile and you still get
this message, check out any code in the form's Open
eventhandler.

Hope This Helps
Gerald Stanley MCSD
-----Original Message-----
Can anyone help? I'm new to Access........

I created a subform within a form. The main form had a
Click to expand...
button which took the user to yet another form and this
worked fine. Then I moved the button to the subform rather
than the main form. I amended the code to point at all the
right forms but now when I click the button I get this message:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"The OpenForm action was canceled" 3
2 Forms and 2 tables 2
Open Subform to specific record 6
Update subform with combobox change on main form 1
How do I use a combo box value in a query? 7
A2000 form ceases working under A2002 1
Pop-Up Subform not linking to Main Form 2
Automatically update the foreign key in a subform 4

Top