Reputation: 1044
Is it possible to move the "New Record Row" in an Access table to the beginning of the table?
For example, say you have 200 items entered into your table, you would have to scroll the whole way down to the bottom of the table to enter a new record.
Instead, your entry row would be in the first row of your table.
Can this be done?
Upvotes: 0
Views: 1036
Reputation: 91376
Use a form or datasheet and open it in add mode, rather than edit mode.
DoCmd.OpenForm "Form1", , , , acFormAdd
-- http://msdn.microsoft.com/en-us/library/office/ff820845.aspx
Upvotes: 1