M
mcar
I have a form that has 2 subforms and I would like to copy all information
from each of these forms to a new record with a click of a button so that I
can change some of the data in each form/subform to make it a different
record without having to retype or lookup all the information again. My form
is set up like this:
PROJECT(main form)
has many SESSIONS that are based on the PROJECT (subform)
which has many PRODUCTS based on each SESSION (sub-subform)
I've tried select record, copy, paste but that only moves the record that I
select. I don't know enough about VB to write a code which is what I need.
I have lookup menus associated with each of the subforms but we don't have
the time to "redo" the entire form/subform manually.
Can anyone help me out?
Thanks
from each of these forms to a new record with a click of a button so that I
can change some of the data in each form/subform to make it a different
record without having to retype or lookup all the information again. My form
is set up like this:
PROJECT(main form)
has many SESSIONS that are based on the PROJECT (subform)
which has many PRODUCTS based on each SESSION (sub-subform)
I've tried select record, copy, paste but that only moves the record that I
select. I don't know enough about VB to write a code which is what I need.
I have lookup menus associated with each of the subforms but we don't have
the time to "redo" the entire form/subform manually.
Can anyone help me out?
Thanks