Question: have effect on or in?
Answer: According to Oxford Advanced Learner's Dictionary, effect selects the preposition on. Actually, either works, but the two function differently. "On" precedes whatever is directly affected, whereas "in" often specifies a subgroup studied, a specific context, etc.