G
Guest
I am relatively new to database design so forgive me for my ignorance.
I have developed a new database for data entry in my department. I keep
having the problem where the users will receive the error "Cannot go to
specified record" when they are trying to click the Submit command button on
the data entry form. The database will be working fine but all of the sudden
this error will start to occur with several users.
The command button has the following code:
Private Sub Submit_Click()
On Error GoTo Err_Submit_Click
DoCmd.GoToRecord , , acNewRec
Additional information:
At peak times the form has about 50 - 75 users.
Security was set for each user through the security wizard
The database is not split
Do I have too many users at one time or do I need a different code for the
command button? I keep seeing references to me.dirty code but I don't
understand what that code does.
Thanks for your help.
I have developed a new database for data entry in my department. I keep
having the problem where the users will receive the error "Cannot go to
specified record" when they are trying to click the Submit command button on
the data entry form. The database will be working fine but all of the sudden
this error will start to occur with several users.
The command button has the following code:
Private Sub Submit_Click()
On Error GoTo Err_Submit_Click
DoCmd.GoToRecord , , acNewRec
Additional information:
At peak times the form has about 50 - 75 users.
Security was set for each user through the security wizard
The database is not split
Do I have too many users at one time or do I need a different code for the
command button? I keep seeing references to me.dirty code but I don't
understand what that code does.
Thanks for your help.