Are you in query design view (with the grid)? If so, you should see the table
that you are updating and be able to see the fields. If you are basing the
update query on another query, check the base query to see if it has the other
fields in it.
If the upper portion of the query is missing (tables area) then you need to
drag down the section of selecting fields and setting criteria. If that does
not work for you, then
switch to SQL view,
copy the text,
open a new query (don't add any tables),
switch to SQL view,
paste the text,
switch back to design view and
save the new query (with the same name as the old if you want)
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
