I need to develop a way to copy contents from one sub-form to another sub-form. I have three sub-forms on a main form. The three are next to each other left-to-right. The two left-hand sub-forms are bound to tables and the data being shown is locked. The right-hand sub-form is bound to a table also but think of it as a new record that is being created. If I double click one of the fields shown in one of the two left-hand sub-forms, I want that data to be copied over to the right-hand sub-form.
Actually, if I could click and drag the contents from one of the two left-hand sub-forms I would but I'm not sure that's possible, correct? So I'm opting for the double-click method instead.
What would the VBA code look like to accomplish this?