Updating a record in a table

[woknick]

Im trying to write a query that will take a value from a textbox, find that value in another table, and update a row in the record.

So a value is entered in the Barcode table through a textbox, example 110, I need the query to search ProductList to find that value. Then once that value is found, I want field Quantity to be increased by one.

Here are my tables

Barcode
BarcodeID

ProductList
Quantity
BarcodeID

I hope this makes sense, thanks in advance








I hope this makes sense. Thanks in advanced

 

[RichO]

How about this:

UPDATE ProductList SET [Quantity] = [Quantity] + 1 WHERE [BarCodeID] = [Forms]![MyForm]![txtBarCode]