I have a form that has a sub form. Each is based upon different tables. What I would like to do is update the fields in the sub form with the fields selected on the main form.
An example would be: Click on field one in the main form and have this value pasted into field one in the sub form.
It would be nice to use the OnClick function to do this. Is this possible? And if so, how do is it done? The fields are the same name and data types in both the form and sub form.