I am familiar but rusty with vba for excel but trying to apply what I know in an MS Access database with no luck.

My table has the fields “Tool”, “Color”, and “Status”. The goal is to change the status of a tool of a specific color from an inputbox. For example in the inputbox there will be 2 sections to input the Tool and color. (Ex Hammer, Blue) then with a click of the update button the corresponding status field entry changes from “Active” to “Inactive”.

Thanks in advance.

I have tried referencing similar posts but excel macros and access macros are not 1:1 on the coding side which has left me confused.