I use access to track inventory. When I notice an item in a new location I have to add a new record. When I do this I loose my place in the data. So I have to scroll through the data table to see where I left off. I need to be able to review and see if the items are in the correct location and that the quantities are accurate along with outer things I am tracking.
Ideally I would like to add a new record. Resort the data by location and return to the new record.