Combining two Queries

[woknick]

I have a query.

UPDATE Product SET Product.[In Stock] = ([Product].[In Stock]+1)
WHERE ((([Product]![ProductId])=[Forms]![Main Menu]![txtBarcode]));


What I want to do is use the 1st query but I want to use the Left$([txtBarcode],3) to substitue [txtBarcode]

Thanks in advance

 

[namliam]

UPDATE Product SET Product.[In Stock] = ([Product].[In Stock]+1)
WHERE ((([Product]![ProductId])=left$([Forms]![Main Menu]![txtBarcode],3)));

Thats all there is to it.

Greetz