how to stop automatically save option for master/child forms in access 2007

[sireesha]

how to stop automatically save option for master/child forms in access 2007.depending on condition only it saves. my child form/subform is in datasheet view.
i write a code in vba for required fields . if required fields entered only save the record otherwise don't save.


if access is not saved data automatically my code works.

So Please Help Me.

[RuralGuy]

You would have to issue a Me.UnDo in the BeforeUpdate event of the SubForm.

[sireesha]

You would have to issue a Me.UnDo in the BeforeUpdate event of the SubForm.

In the subform, only enter and exit events are there. there is no beforeupdate event.

i had given me.undo in beforeupdate event but its not working.

i had tried validation check i.e., isnull(fieldname)=true in form_beforeupdate it gives errors. so i changed code to save button. it works fine. but the problem is access saves data automatically. if this option works, using my code save the records into table. Please help me as early as possible.

[RuralGuy]

Me.UnDo in the BeforeUpdate event of the SubForm (not the SubForm control) *will* keep the SubForm from creating records.