What do you mean--that you want all fields in the query updated the same way depending on an initial choice the user makes, or that you want the user to be able to choose for each entry? In either case, I don't think it's possible to create pop-up list boxes using queries, so you either need a form or you can use one of these alternatives:
If you want all entries in Table1 updated to the same user-defined value, then in the "Update To" field put something like [Value you want to update to:] - this will prompt the user with whatever message you put in the brackets, and will then update with whatever value they enter.
Or, if you really want a list of options for the user, you could make it a two-step process. Make a table (we'll say Table3) with just one field, and make that field a List or Combo Box (under the "Lookup" tab in design view), linking it to the list in Table two. Now make just one record, and that can be your update source. The user will need to edit the table before each update, but at least they'll get a drop-down list of options.
If you want the user to be able to choose a value for each record in Table1, then you can
simply make the field within Table1 a lookup field (as in the other method above), and have the user edit Table1 directly.
