I've chk'd previous topics like mine and am still stuck...want to use code and not action queries..the two forms open w/matching helpnos...need the sql to find and only do the updates to that matching helpno..may involve the where clause..I made an update qry and viewed the sql, it uses inner join and where clause now how do I incoporate into code..I must be dumb cause I am missing fital piece somewhere..thanks if anyone responds...