Dynamic row reordering in datasheet

L

Leif

I have a form that displays information in datasheet view. The recordset is
based on a select query that has no order by clause. However, when I add a
new row sometimes, after I enter the row, the row jumps to top row. This
only occurs sometimes and I not been able to determine why it happens. Has
anyone seen this happen and understand why?

Thanks,
Leif
 
R

Rob Oldfield

Possible that users are applying a sort to the form when using it? That
could potentially cause this kind of thing.
 
L

Leif

Rob,

Thanks for your suggestion. No, there are no sorts being applied. I know
that since its happened to me, and I didn't sort.
 
Top