Entry field at top of table

[Coleman984]

Is there a way to make the entry field at the top of a table instead of the bottom?

 

[John Big Booty]

Give that tables are really only for the storage of data, and that the user should not be interacting directly with the data stored in that table, but rather through the "filter" of a form. Why does it matter, give that that data can be sorted in any manner you desire?

 

[Coleman984]

Well then how would I do that? The way I have it setup is a form with text boxes showing in datasheet view. The entry field is at the bottom of this datasheet view form. Which after awhile would get annoying to scroll to the bottom to enter data.

 

[Galaxiom]

The OrderBy only sorts the existing records. The NewRecord is always at the bottom of a datasheet.

Include this line in the OnLoad Event Procedure to get it to open at the new record. You can also put it on a button.

RunCommand acCmdRecordsGoToNew

 

[Coleman984]

The OrderBy only sorts the existing records. The NewRecord is always at the bottom of a datasheet.

Include this line in the OnLoad Event Procedure to get it to open at the new record. You can also put it on a button.

RunCommand acCmdRecordsGoToNew

Since this is a subform that I was talking about I just put it on the click event. So anytime someone clicks on the form it will take them to the new entry field. Good suggestion thanks.