I have a database originally written for Access 2013 that we are now using with Access 2016. We've been using the Primary key as the tracking number for several years, which I'm learning isn't the ideal way of doing things. Traditionally, we have been able to use the navigation bar as a "goto record" by typing in the primary key number followed by enter and that has taken us to the correct record. Somehow, we've managed to delete some records so now when we enter what we have as our "ID" we end up on the wrong record since we now have more numbers created via Primary Key designations then remaining records.
To minimize confusion going forward, I'd like to hide the access navigation bar and generate a new one. I've created the appropriate buttons, generated a functional "GoToRecord" combo box and tagged a text box to the primary key to show what record is being edited. This approach does work, however, what I'd really like to be able to do is have something like the Access Record number field where I can either enter the ID number and have it go to that record, or have it update itself to the current. Is this possible? I have a decent understanding of Access, but don't understand VBA codes very well so I'm not even sure where to to begin trying this. Any help would be appreciated.
To minimize confusion going forward, I'd like to hide the access navigation bar and generate a new one. I've created the appropriate buttons, generated a functional "GoToRecord" combo box and tagged a text box to the primary key to show what record is being edited. This approach does work, however, what I'd really like to be able to do is have something like the Access Record number field where I can either enter the ID number and have it go to that record, or have it update itself to the current. Is this possible? I have a decent understanding of Access, but don't understand VBA codes very well so I'm not even sure where to to begin trying this. Any help would be appreciated.