How can I make the blank New Record row appear at the top of a datasheet rather than at the bottom?? I would like to be able to do this for tables themselves as well as forms and subforms in datasheet view.

Thanks for your help!

Welcome to P2P. That is a very interesting question. As far as I know, new records seen in datasheet view of a subform always show up at the bottom. There is no setting to put it on the top. It would make sense to do that, say, if you sorted by latest date on top and wanted new entries to appear on top.

Barring anything I'm not aware of, you can set the datasheet view NOT to allow additions. It will get rid of the that last line. Then you can put textboxes on the main form with a SUBMIT or ADD button. People can enter the new data up there on top (or wherever you want). When the user clicks ADD, the record is added to the subform.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Thanks Greg. Real estate on my form is a bit of an issue, so I was hoping to be able to add new records to a subform right onto the subform datasheet.

Problem is, the user has to scroll down to find the new record row, or else (if I set the form to go to the new record row on load), forgoes seeing the first rows of the table, which are important to the context of the project.

I suppose I could reverse sort, but the subform is a kind of timeline/calendar so it would be a little odd to have the dates going in reverse order.

Anyway, it is reassuring to know that I am not missing something simple (just started playing with Access a few weeks ago).

Thanks for your help and let me know if you ever come across a way to do this.

Kimber

Well, as before, keep the datasheet Allow Additions = False; and then if you're short on real estate you can put ONE little "Add" button on the form. When they click it, a second pop-up form will appear allowing you to enter the new data. You click the OK button on that 2nd form and it closes, refreshes the list, and sticks the new data on the list.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division