H
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
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