I've recently had an occasion to copy a record to another table:
Code:
CurrentDb.Execute "INSERT INTO tblAutoTrans SELECT * FROM tblRegister WHERE TRecID =" & Me.TRecID & ";"
The code works fine but I'm surprised that the newly created record in table "tblAutoTrans" was not assigned a new primary autonumber value in its record ID field. Is that normal with such cases as with this copy operation?
Would it be a more preferred approach to open a DOA Recordset of the target table and use AddNew to copy the desired fields?
Bill