hi there. I done this before, with the help of u ppl but now i have forgotten.
there is a subform in the table and that updates fine, so when u change the record, the values in the previous record are NOT copied,
i just created a new subform and the values DO copy and I don't want that.
how do I solve it?
for example, record 1 may have employee number 2 assisting it, but then when u change it to record 2, that employee number is the same, and even if u change the employee number, that NEW employee number is copied to all the other/previous records!
help
there is a subform in the table and that updates fine, so when u change the record, the values in the previous record are NOT copied,
i just created a new subform and the values DO copy and I don't want that.
how do I solve it?
for example, record 1 may have employee number 2 assisting it, but then when u change it to record 2, that employee number is the same, and even if u change the employee number, that NEW employee number is copied to all the other/previous records!
help