Need Some help with access

[DimShadow7]

I've been stuck on this little coding problem for a while, and I figured this would be a good place to find some help.

 

I've got an access table that keeps track of inventory, pretty much has a product SKU and a UnitsInStock field.

 

I want to create a form that will allow me to scan in new products with a scanner. Pretty much I need a text box that will have the scanner input values and then have it increment the UnitsInStock field for that particular SKU by 1.

 

I haven't been able to get this to work yet!!!

 

Any help would be greatly appreciated.

 

Thanks in advance,

DimShadow7