B
Bill
Hi,
I have a form with a subform in a parent child realtion.
Such that each record/row of the subform has the forms identifying ID.
I would like to be able to take the information in the subforms table (each
row) and be able to paste it into another new open form.
The original form has information which is repeated and can be used in other
forms - a purchase order - the purchase is repeated at different times but
the quanitity and description do not change - only the date and a different
purchase order number.
I open the new form - I select the old record which the new form is to be
based on.
Once the past record is selected the information in its subfrom now
populates the open form and its subform.
(I have created a query that uses the old record number to flter out the
required rows.)
So that these values (say 30 lines) can be copied into the new form and
entered in that subform but with that new forms ID - can this be done with
insert into and if so how?
I have an idea of taking the filtered query and creating a temporay table
which can be used to insert back into the subforms table - not sure if this
correct or how to do it.
How can I copy part of a subforms recorset (e.g 30 rows) back into the
subforms table but with the new ID showing for each of the copied rows
entred?
Hope someone can help.
Thanks in advance
Bill
I have a form with a subform in a parent child realtion.
Such that each record/row of the subform has the forms identifying ID.
I would like to be able to take the information in the subforms table (each
row) and be able to paste it into another new open form.
The original form has information which is repeated and can be used in other
forms - a purchase order - the purchase is repeated at different times but
the quanitity and description do not change - only the date and a different
purchase order number.
I open the new form - I select the old record which the new form is to be
based on.
Once the past record is selected the information in its subfrom now
populates the open form and its subform.
(I have created a query that uses the old record number to flter out the
required rows.)
So that these values (say 30 lines) can be copied into the new form and
entered in that subform but with that new forms ID - can this be done with
insert into and if so how?
I have an idea of taking the filtered query and creating a temporay table
which can be used to insert back into the subforms table - not sure if this
correct or how to do it.
How can I copy part of a subforms recorset (e.g 30 rows) back into the
subforms table but with the new ID showing for each of the copied rows
entred?
Hope someone can help.
Thanks in advance
Bill