Clear Data Entry in Datasheet SubForm Problem

[tndinnc]

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?

[ssanfu]

I would try adding a line before the Cancel = TRUE line:
(-- untested --)

' code
  Me.Undo
  Cancel = TRUE
'more code

Also, see the response by Allen Browne at
http://www.pcreview.co.uk/forums/dif...-t1162440.html

[tndinnc]

That worked great thanks!