Wayne,

Thank you very much for the insight in how to perform this update. I apologize for not getting my original post setup right. The code worked perfectly.

Thank you ...

thanks for the reply but I need to update the altname1 and altname2 fields, not the name field, with the two entries in TableB for the acctno.

thanks

terry

please disregard this post as i inadvertently hit submit.

terry