Hi Troy,

It appears you have 2 tables

1) dbo_tblProduct

  which is possibly a link to a SQL table?

2) DEV_dbo_TblProduct

  possibly a local Access table that shares
  14 fields in common with to the first table

and you would like to update the 14 fields
in DEV_dbo_TblProduct to the current
values of the corresponding fields in dbo_tblProduct?

Is the above correct?

If so, is there a field (or fields) that they share in
common that determines a distinct row in each
table, and a distinct row match between tables?

I might start the update query with a simple SELECT
query where you join the 2 tables on those fields,
then bring down the 14 fields from each table,
and in Criteria row under DEV_dbo_TblProduct
fields, type in as you said

Field:   field1
Table:  DEV_dbo_TblProduct
Sort:
Show: <checked>
Criteria: <> dbo_tblProduct.correspondingfield1
Or:

Once verified that SELECT query is returning
correct records to be updated (and you can see
field values from both fields to check), then
delete the fields from dbo_tblProduct from grid,
change your query to an Update query, and
fill in Update To: row under remaining "DEV" fields in grid.

Field:   field1
Table:  DEV_dbo_TblProduct
Update To: dbo_tblProduct.correspondingfield1
Criteria: <> dbo_tblProduct.correspondingfield1
Or:

Actually, on many occasions, if fields share
same names, Access will do a pretty good
job filling them in with best guess from the join
when you change to Update query.

good luck,

gary