I have an inventory DB that scans product bar codes and enters the barcode number in a [Products] field and then sets a default value of 1 for each record in the [quantity] field
It then it goes to the next record for the next scan.
When all scanning is completed I run a report that provides a total number of times each bar code has been scanned buy totaling the quantity field of each of the same [products] scan record.
My issue is that when I have a quantity of like 50 then i have to scan 50 of the same item. I would like to create a button where after scanning an item i could click on a button and it would back tab to the previous record [quantity] field, which is the last field in (table view) and enter a value of 50 and then tab back to the new record for the next scan.
A send key of {backtab},50,{tab} would do the trick but i cant find it in Access 2016. Any suggestions?