the uncommited changes error because of the delete statement:

DELETE FOR pk=findpk in vtemp
DELETE FOR fk=findpk IN vtempdetail
thisform.addnew

if I remove the delete code, I won't get error message.

any suggestion?

thanks for the help

regards,

Jerry