I have a button on a form, with a macro assigned to OpenForm. I'd like the macro to accomplish several additional actions. Here are all the actions, in order, that I want the macro to accomplish when the button is clicked:
1. Copy data from "Field A" of the presently open form.
2. Copy data from "Field B" of the presently open form.
3. Open another form. (This function is already assigned to the macro.)
4. Paste the "Field A" data into a particular field, in the newly opened form.
5. Paste the "Field B" data, etc.
Is it possible to accomplish these actions with a macro?
Thanks,
jkk