ms access - Form with required field. Deleting the new record -

i have form bounded table , have 1 required field in table. when try enter new record through form, , decide not enter record, stuck, keeps saying need enter value required field. there way form have submit button, , when click button, record goes table , otherwise gives me interface through form can edit values without worrying required fields. appreciated! other approach welcome too!

as add data record access creates record (and assigns id#). in before update event control required field, check see if value null, , if so, undo changes. example:

private sub txtcontrolname_beforeupdate(cancel integer)   if isnull(me!txtcontrolname)     me.undo   end if