On Fri, 21 Mar 2008 17:19:01 -0700, Pennington
wrote:

Thanks, I will try Evi's solution but when I read the blurb in the Access
Help I got the impression that I had to type an expression or value in the
Update To cell and I didn't want to have to do that - I just wanted to
replace the content if it was different. In fact it would not matter if all
matching cells were replaced even if there was no difference.

The expression can be - and would be, in this instance - something like

[Othertable].[fieldname]

--

John W. Vinson [MVP]