Update query depending on parameter

[david444]

is it posible to use the input from the user from a parmeter as the 'update to' field in the query design.
e.g. I have a table containing prices for computer parts. I want to be able to use a query to increase the prices by a value input by the user. Any suggestions?

 

[Nouba]

This could be done by an Update Query in which you can set the Parameter to your control on the form.

UPDATE YourTable SET YourPriceField = YourPriceField + [Forms]![YourFormName]![YourControlName]