I have a form that is based on a query which is taking data from three forms. I need a button on the form that that change the value of a field depending on the value of a dropdown box on the form. Its a student form and all the students are in a specific class. The thing i want to achieve is to promote students of a specific class to another class depending the class name (which will be in the comboBox). Kindly assist how to achieve this. Thanks!