Want AddNew record at EOF not BOF

[hortensio]

Hello,

I am using AddNew and it always places the new record at the beginning of
the file and I want it at the end. I can sort it - but I am looking for a
way to add the data at the EOF. I have tried a variety of things with no
luck, here is a sample:

With rst_tbl0001
.MoveLast
.AddNew
.Fields("Parent") = "RecordID"
.Update
End With