I have subform in datasheet view. The subform allows the user to add additional information relating to the order on the main form. All the fields on the subform are required. I have code in the beforeupdate for this subform. If a user tries to leave the row (click the next row or outside the subform) before all the required information is filled out, it presents a message saying x,y,z is required you wish to continue Yes or No. Yes works fine - it lets them go back to data entering. No - doesn't work. what I want to happen here is to set the subform back to what it was before they started entering the new record. I've tried setting cancel = true then me.refresh, me.requery, also tried setting the controls values to null or "" ... nothing works. Anyone have any suggestions on what I am doing wrong here?