Access Subform Inventory Transaction 2

[MrNick]

I have been building an inventory program for my business using Access. So far so good. But as the year has gone by my employees spend a considerable amount of time scrooling down to the last row to enter a new transaction. Is there a way that I can make the next transaction entry appear at the top of the form other than at the bottom?

 

[DanJR]

An easy method is to put a button on the form that takes the user to the new record e.g.
[tt]
Private Sub cmdNew_Click()
'goto new record
DoCmd.GoToRecord , , acNewRec

Exit Sub
[/tt]
Cheers,
Dan

 

[gusbrunston]

[tt]
I like to show the transactions sorted from earliest to latest, and then leave room at the bottom of the form to enter new transactions.

Put this is the On Current event of your form:

'this will put last record at the top
DoCmd.GoToRecord , , acLast
'this will push the last record down by 10
DoCmd.GoToRecord , , acPrevious, 10

[tt] Gus Brunston - Access2000(DAO)[/tt] Intermediate skills.

 

[MrNick]

Thanks for the replies. Yes I know how to sort by date. I just want the abilitiy to have the very first line instead of the last available for posting. If we need to check a customers history for a specific item, then we can scrool downward. By having the very first line available for posting, data entry would be greatly improved. Additionally this will aid at the end of the year. We will not have 300 line entries to scrool down or hot key down to post a current entry for the current year.