I have created a combo box in a form. The user can select two options. If a specific option is selected, values earlier inserted in a specific field of a different form should be automatically removed there and inserted in the column which is selected in the other form. Does anybody know how to achieve this in MS Access? I am a total beginner at VBA code. Would it be an idea to create an event procedure on change where I update the fields in the first form based on the selection of the combo box?