I made a table, form and report to show me information of clients being these: name, phone, company, city etc.
I also put a special form of identification through macro where when typing a number from 1 to 3 and depending on one of these values, a rectangle changes color . However, when I register another client, the value resets normally, but the rectangle does not . If for example I put the value 1 on the client A, the rectangle is green, on the client B the value 2, the rectangle is yellow, but when I return to client A, even with the value 1 the rectangle remains yellow and not green . I placed this macro to run whenever the form was opened / loaded / updated, but no matter where I put it, I get an error 13 of "Type Incompatible" .
I wish someone could help me with this problem, I will send screenshots if necessary .