Auto start next record entry after completion of current record in access
Posted on 2013-01-27
Microsoft Access 2010 working in a continuous form.
I have screen where the user enters data into 15 or so fields. The primary key is [StockNum].
When the user has entered data into the last field [Rec Creation Date], then I would like to automatically enter the edit mode for the next record that needs to be entered.
Could someone please tell me the event and criteria so that I can jump start the next record with the following code after they tab through or otherwise save the new record that they have just entered.
[StockNum] = Nz(DMax("[StockNum]", "[tblStockItems]")) + 1