What is the easiest way to transfer a record from one table to another. This is the code I am using at the moment which seems pretty useless. There must be a way of transferring the who record rather than, transferring one field at a time to the new table then deleting the source record.

With DataEnvironment1
.rscmdTemp.Open
.rscmdRCode.Open
.rscmdError.Open

Do While Not .rscmdTemp.EOF
.rscmdRCode.MoveFirst
.rscmdRCode.Find ("ResourceCode = '" & .rscmdTemp!Resource & "'")
If .rscmdRCode.EOF Then
.rscmdError.AddNew
.rscmdError!Contract = .rscmdTemp!Contract
.rscmdError!Resource = .rscmdTemp!Resource
.rscmdError!Employee = .rscmdTemp!Employee
.rscmdError!EntryDate = .rscmdTemp!EntryDate
.rscmdError!WComponent = .rscmdTemp!WComponent
.rscmdError!Hours = .rscmdTemp!Hours
.rscmdError!Breakeven = .rscmdTemp!Breakeven
.rscmdError!Sell = .rscmdTemp!Sell
.rscmdError.Update
.rscmdTemp.Delete
'.rscmdTemp.Update
End If
.rscmdTemp.MoveNext

Loop

.rscmdRCode.Close
.rscmdTemp.Close
.rscmdError.Close
End With



Any help would be appreciated

Cheers

Jonny