Error 2105 After Trying to Add New Record

Larissa Marques Freguete 0 Reputation points
2024-06-08T20:18:46.0733333+00:00

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.

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
332 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tanay Prasad 2,115 Reputation points
    2024-06-10T12:26:13.6833333+00:00

    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

    0 comments
  2. Larissa Marques Freguete 0 Reputation points
    2024-06-10T16:01:43.0233333+00:00

    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.

    User's image

    User's image