Using AC2002
Hello. I am working with an existing DB that has "Add New" command buttons on two forms.
When I, an Admin, click the buttons, they work properly, and a new, blank form is created, ready for data entry.
When one of my users from the "Update Data" workgroup clicks the button, they get an "Error 2105: You can't go to the specified record" error, and no new row is created. Each of these are just supposed to add a new row in their respective tables.
Could this just be a security issue; I'm assuming so because Admins can use the button. However, I changed the table permissions to allow Open/Run, Read, Update, Insert, and Delete on all tables and am still having issues. Here is the code behind one of the buttons without errorhandling
Any help is appreciated.
Hello. I am working with an existing DB that has "Add New" command buttons on two forms.
When I, an Admin, click the buttons, they work properly, and a new, blank form is created, ready for data entry.
When one of my users from the "Update Data" workgroup clicks the button, they get an "Error 2105: You can't go to the specified record" error, and no new row is created. Each of these are just supposed to add a new row in their respective tables.
Could this just be a security issue; I'm assuming so because Admins can use the button. However, I changed the table permissions to allow Open/Run, Read, Update, Insert, and Delete on all tables and am still having issues. Here is the code behind one of the buttons without errorhandling
Code:
Private Sub cmdAddRec_Click() On Error GoTo ErrorHandler ' add new record Me.AllowAdditions = True DoCmd.GoToRecord , , acNewRec ' set focus to first data entry field Me.Plant.SetFocus End Sub
Any help is appreciated.
Comment