if you are adding a new product, there is no next record.
1. you can have a continuous form that shows records,
2. click new to open YOUR form to add new. (unbound form) save.
3. Then it closes form, and you are back to the list.
But click ADD button
ask then post data:
If msgbox("Add product:" & txtProd & "?",vbquestion+vbYesNo,"Confirm") = vbYes then
docmd.openquery "qaAddNewProd" 'run append query to add form data to table