RunCommand Action Cancelled

  • Thread starter Thread starter Bonnie
  • Start date Start date
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.
 
It may be that the recordset is opened with locking. look at the record
locks under the data tab of the property sheet of the form in design view.
It could be several other problems as well in a multi-user environment.
 
Back
Top