VBA/ADODB How to change/update value in access database

Hello!

I have a userform in excel that is linked to access database. Whenever I search for the employee/SAP ID# of staff, the userform retrieves all details and allows me to update them, except for the employee/SAP ID# itself. What I want is to have the option also to change the employee/SAP ID in the database.

Thanks in advance for the help!

Here's my code:

In userform there are 6 textboxes. Textbox1 is what needs to be searched.

Please Login or Register  to view this content.

Solved it!

My error was I used the value in textbox6 as my search criteria and not the value in textbox1.

Just fyi, my final code now is:

Please Login or Register  to view this content.

I'd guess that's because SAP_ID is a Primary Key, you shouldn't ever change a primary key that's why primary keys are usually just incrementing numbers that don't actually hold any relevance to the data in the record.

In your database, I suggest adding another field and making it the primary key and removing this from the SAP ID field

Scrap the above, it appears it wasn't a PK after all