Access 2000 Inventory Program Default

[MrNick]

I've asked this before, but couldn't get what I needed done. In the subform area, my data entry personnel spend a great deal of time scrolling down or paging down to enter new transactions in the subform transaction.

Is there a way, like sorting by order that will allow the next data entry in the subform to begin at the top of the subform instead of scrolling down past the old history / or paging down to enter a current transaction?

 

[Steve101]

In Access, data entry is always done at the bottom of a form. Admittably this can be a nuisance. A simple but effective solution is to use the wizard to generate a button on the subform, which allows a new record to be added. This will automatically position at the bottom of the form, without the user having to do this navigation him/herself.

Hope this helps,
Steve Lewy
Solutions Developer
steve@lewycomputing.com.au
(dont cut corners or you'll go round in circles)

 

[MrNick]

Do you mean placing a button for adding new data entry on an item or for adding a new item? We have no problem with adding additional items to inventory, just the data entry on the subform. If just adding a button to the subform to jump to the bottom empty entry line wouldn't be necessary since clicking in that area and hitting page down button would accomplish the same thing. But thanks anyway.