Error 2105 After Trying to Add New Record

Question

Hello, all.

I was wondering if I could get any help on this topic.
I am quite new in this world of dealing with MS Access, database management, and VBA coding. However, I was able to create a front and back-end database so my colleagues could create records of the data our research group created and collected.
I don't think the DB was behaving like that before, but now when I click on the button that has a macro for creating a new record (macro = GotoRecord >>> New), after I am able to add one new record, it works well, I start to receive the message "Error 2105: you can't go to the specified record"

May I have any assistance on this?
Thank you.

Answer 1

The error "2105: You can't go to the specified record" in MS Access typically occurs when there is an attempt to navigate to a record that doesn't exist.

1. Make sure the macro is configured properly. A new blank record should be created with the "GotoRecord" action with the argument "New".
2. Ensure that the form allows new records to be added. In the Property Sheet, set the "Allow Additions" property to "Yes".

If the above workarounds don't work, here's a detailed article on this topic.

Regards,

Tanay

Answer 2

Good afternoon, Mr. Prasad.

Thank you for your prompt response. I just checked those these 2 topics in my db and it seems to be all correct.I am attaching print screens of these settings you mentioned, so you can better understand how my db is set up. Beforehand, I apologize, because it is in Portuguese, so please, bear with it.