Hi,
We technically do no insert record "between" other records.
In a table, the record are NOT ordered (if they are, it is by order of
the value of their primary key, when there is one).
In a record_SET, the ORDER BY clause define the order in which the
initial records are "linked" (for moveNext and movePrevious). If there is no
ORDER BY clause in the SQL statement used to fill the recordset, the order
is the one the database engine "through out" the records, accordingly to the
query plan it decided to use, at the moment. New records are append (to the
end), and if you want to reshuffle the records accordingly to the order by,
after having appended records, you can try a requery.
Hoping it may help,
Vanderghast, Access MVP