C
Cindy at TRW
I have a form based on a table that data is in entered into. This form is
for production counts - a "Paid" field and a "Full Pallet" field, plus
several other fields but these are the two that I need help with. The way
our part numbers and the process of the part are set up I need to take the
data from those two fields and create a new record with a new part number. I
thought I could use an append query, not so since I actually need to create a
new record not append a record. We have two production lines that these paid
and full pallet counts are entered into - then two more records need to be
entered for the "painted" parts which are different part numbers. I was
hoping to be able to have a query or macro run when the form is closed that
can automatically create the two new records without having the person doing
it manually. Thanks for your help!
for production counts - a "Paid" field and a "Full Pallet" field, plus
several other fields but these are the two that I need help with. The way
our part numbers and the process of the part are set up I need to take the
data from those two fields and create a new record with a new part number. I
thought I could use an append query, not so since I actually need to create a
new record not append a record. We have two production lines that these paid
and full pallet counts are entered into - then two more records need to be
entered for the "painted" parts which are different part numbers. I was
hoping to be able to have a query or macro run when the form is closed that
can automatically create the two new records without having the person doing
it manually. Thanks for your help!