Increment Qty from Scan

You can't do this in one step.  First you need to use something like a dLookup() to determine of the Barcode already exists.  If it exists, then you would run an update query to increment the quantity field.  If it does not exist, you would run an append query to add a new record.

Oh ok .. but I'm actually scanning the data in from each product. (This is how its added)

If I was to have the data in an Excel file (Barcodes) could it then be done?

Scanning into Excel rather than an Access form just adds unnecessary complications and you have the same issue.  If the Barcode exists, you need to UPDATE but if the Barcode does not exist, you need to INSERT.  These are two different operations.

I'm scanning into Access, not Excel.

I am adding all the barcodes from each stock item into an access database.
Each scan is a qty so many scans of the same product I want to consolidate those same products.

Awesome! That's it. Thank you so much.

Just one other thing, are you able to tell me how to set the default Qty to equal 1 and enter automatically?

Yes:

Private Sub UPC_BeforeUpdate(Cancel As Integer)
    
    Dim rs  As DAO.Recordset
    
    Set rs = Me.RecordsetClone
    rs.FindFirst "UPC = '" & Me!UPC.Value & "'"
    If Not rs.NoMatch Then
        rs.Edit
            rs!Quantity.Value = rs!Quantity.Value + 1
        rs.Update
        Me.Undo
        Cancel = True
    End If
    rs.Close
    
    If Not Cancel Then
        Me!Quantity.Value = 1
    End If
    
End Sub

Select allOpen in new window

I would not scan into a bound control.  You don't want to dirty the current record with a duplicate barcode.  If you do, you will also have to deal with that issue because you don't want Access to try to save the duplicate record.

As I suggested earlier, don't even use the form's recordset.  Just run update or insert queries.

You can provide the value for the quantity in the insert as Gus suggested or you can modify the table design and set 1 as the default value for the quantity.

Try my clever demo. There will be no duplicate barcode.
StockCount.accdb

I am stocktaking barcodes so there will be barcodes which are the same.

Thanks, Gustav Brock that is awesome!

My last question is, when you enter a new barcode the default qty is 1, then you need to hit the "Enter" key to accept the data. Can the "Enter" key step be automated so you don't need to touch the keyboard at all? Just scan and accept.

Gee your good! Thank you, that's brilliant!

You are welcome!