Thank you for the code. I tried it but I keep getting error messages:
if I use "DoCmd.GoToRecord , , acNext" then I get "Run-time error '2105' You can't go to the specified record" error message
if I use "DoCmd.GoToRecord acDataTable, "Kits", acNext" or "DoCmd.GoToRecord acDataForm...