Update Query to Choose Criteria

[mimminito]

Hello, i was wondering if you could help.
I want to run an update query, taht updates prices in a table. But i would like to be able to choose the criteria when the query runs, for example a message box appears, that will allow me to enter a certain amount for the prices to change by. Could someone guide me on how to do this? thankyou, its much appreciated

 

[Dennisk]

in your criteria row enlclose your prompt in square brackets

=[Enter Surname]

when you run the query an input box will appear with your prompt.

 

[mimminito]

yes i can do that, but what i want is to use an input box so that i can enter a price, and it will update the prices using what i enter. if i do as you say, it will just search for people with that surname, i want to be able to enter a price, then it take the price and use it as the updateto section of the query

 

[Dennisk]

Refere to the form using the following notation

Forms!yourForm!yourControl