New record on top

A

austin

Is it possible to have the new record field stay at the top of the table
instead of scrolling all the way down?

thanks
 
J

Jerry Whittle

In a word: No. At least in a table. You might be able to have it work in a
form.
 
D

Dennis

Jerry's right. What I did however, was that even though the "new" record had
to be added at the bottom (on a continuous form), I did a "requery" after
posting the new record. The sort on the query was such that the new record
automagically appeareed at the top of the records. In other words, the native
sort of those records was latest added -> earliest added.
 
D

Douglas J. Steele

I think it's only possible in a form if you use 2 subforms: one (at the top)
a single row high, with the DataEntry property set to True, and one
(underneath) that shows more rows of data, with the AllowAdditions property
set to False.
 
J

Jeff Boyce

You are working directly in the table?!

Remember, Access is not a big spreadsheet. Tables are great for storing
data, but forms do a much better job of displaying it...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top