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
Expand|Select|Wrap|Line Numbers
- 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.