thanks Nico,
i got around the autonumber audit number problem anyway by just appending a new audit number which was (Max +1) of the the audit number field, with other data which is appended.
Ben...

Hi,
I am trying to append a list of part numbers which is generated in a seperate table into a subform table which is on a main form. My main problem with getting it to work is that I need the part numbers to be appended to the subform table after the autonumber (audit no) has already been assigned on the form which is done by hitting the new audit button(creates new record). Critically the part numbers need to be appended to match the autonumber...