New record on top

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

thanks
 
In a word: No. At least in a table. You might be able to have it work in a
form.
 
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.
 
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subform bottom to top 7
Excel Excel spreadsheets opening at top instead of bottom. 4
Form View 1
Adding new record 4
What strategy to add a new record on subform? 2
Allow Additions Sort Order 3
mouse scrolling thru records 1
Frame control scroll bar 0

Back
Top