Update Query Which Asks Question

[jhillbrown]

I have an update query which works just fine. It is replacing the contents of a field called Price Per Person with an amount I specify in Update To. Is it possible to incorporate this query in a macro and have the query ask me what the new price is that's suppose to replace the old price? Thanks!!

[pbaldy]

You can refer to a form for user input or have the query prompt:

UPDATE TableName SET FieldName = [Enter new amount]

[carlmdobbs]

Hello. A query prompt is probably the least professional way of getting the information from the user. It is inadequate because it doesn't do the following:
1: Verify that the user put in correct, useable information
a) right data aype
b) correctly spelled
c) put in anything at all
2: Doesn't give the user a chance to cancel the operation mid-stream.

There are two bettwer ways. One is create an imput box in code.
dim x as variant
x = inputbox("Give me the last name"
There is an argument for a default value

The user puts in some informaiton.
Then verify.
If isnull(x) then
msgbox "Cancelled."
exit sub
End If
If Isnumeric(x) then
msgbox "You must enter a name, not a number."
Exit sub
End If

You get the idea.

The best way is to do what someone else already said. Make a pop-up form to ask the user to put in information using a drop-down box or list box that has a list of correct choces. Then refer to the field to obtain the value and assign it to a variable. Use code to qualify the answer, if needed or to see if anything was selected at all.
A form is better than an input box, still, even if it has no list or combo boxes because the answer put into the form does not have to be from a list or combo box. It can be evaluated if it is put into a text box. The text box can be formatted for dates, phone numbers, etc. which insure the data is correctly entered.
Please remember that MS Access wizards are for the uninitiated programmers, (power users). That is okay, but professionals have to worry about data integrity and keeping the program bullet proof. We have to anticipate everything that can go wrong because everything will go wrong. Query prompts don't fit the bill. So ignore the query prompts as a means of getting information. That is a rinky-dink method. Go for an input box if the answer to a question is genuinely unpredictable (like , "What is your favorite animal?" whch is imipractical to put into a list.)

[maximus]

very well answered it is exactly how to do it.