thanks again.
iam not very experienced with vba. when i tried to do what you told me it said. compile error
only comments may appear after endsub end fuction property.
what did i do wrong??
nd Sub
If MsgBox("Are you sure you want to save this record?", vbYesNo + vbQuestion, "Save...