Form in datasheet view

[ijit]

Is there a way to make a form in datasheet view reverse direction. So the newest entry is at the top? That way, everytime I load the form the most recent entry is visible and it is ready for a new entry. Right now I have to scroll through all the entries before I get the new one.

 

[rainman89]

theres a sort option that you can look into. is the form based on a query?

 

[ijit]

No, it is linked directly to a table.

 

[neileg]

You should base your forms on queries even if you are only using data from one table. Then you can apply the sort in the query.

However, regardless of how you sort the data, inserting new data is always at the bottom.