R
Robseym
I have a form to collect data for a table. On selecting one option a new form
opens with a new record in the same table which collects different
information but for the same table. The new record also needs to have values
set for a large number of fields based on the record that was being completed
on the first form. I know how to use the set value action in a macro but is
there a way of doing that quickly for a larger number of fields rather than
having say 20 setvalue actions?
A couple of points:
1) I do not know anything about VBA and I don't want to start for this small
project
2) If this sounds cumbersom bear with me I need the table for a mail merge
Thank for any help in advance
Rob
opens with a new record in the same table which collects different
information but for the same table. The new record also needs to have values
set for a large number of fields based on the record that was being completed
on the first form. I know how to use the set value action in a macro but is
there a way of doing that quickly for a larger number of fields rather than
having say 20 setvalue actions?
A couple of points:
1) I do not know anything about VBA and I don't want to start for this small
project
2) If this sounds cumbersom bear with me I need the table for a mail merge
Thank for any help in advance
Rob