RunCommand Action Cancelled

B

Bonnie

Using AXP. I have a form for adding new records only so
each time you open up only the one new blank record is
there and as you add more and more the number of records
grows. (If you close and reopen, you are back to only the
new record available.) I have a number of non-admins users
that have edit and insert rights that are getting an error
when they try to add another record. They are all
getting "Could not update; currently locked" error
messages. They can close and reopen the form and continue
but it is a pain.

I have an Add New Record command button that I have added
the line DoCmd.RunCommand acCmdSaveRecord but I'm getting
a dialog box that says "The RunCmd Action was cancelled."

I have tried separate buttons but the users are still
getting "Could not update; currently locked" messages. Any
thoughts? I appreciate all the great folks jumping in to
help. I know I'm missing something simple.
 

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

Top