Update Query, Asking for user input for "Update to"

[etdahmer]

I have an Update query that I need to run on a lot of data. For each set of data the information that is being changed/updated is the same for all records. The data that is being "Update to:" is different for each set of data. I have the query asking for user input to define the query criteria. However, I can not figure out how to have the query ask for user input to define what the updated data should be.

[June7]

Personally, I would not do this with an Access query object. I never use dynamic input popup prompts. Cannot validate user input.

Better to use a form for the user inputs and then code references the controls on form. Validation can be built into the controls and in code.

VBA code would run an sql action statement, like:

CurrentDb.Execute "UPDATE tablename SET fieldname='" & Me.tbxUpdateTo & "' WHERE fieldname='" & Me.tbxFilter & "'"

This example assumes the fields involved are text type.

[etdahmer]

Thank you for the reply. I had a feeling that it would be better to do it that way from what I have been reading. That is something new for me. Was trying to just create a quick and dirty way to do this. As for the data validation that isn't a problem here because this is just an Admin function that I will be doing myself.

Thanks again for the help.

[June7]

Okay, if it's just for you and not users, then by all means, use a popup prompt.

In the UpdateTo row, just put something like: [enter value to update with]