requested enter data when close a data add form

[newaccess]

I use form wizard to auto generated a form to add data form.
When user open a form with default value assigned. But if user does not like tot enter data and
want to close form. access 2007 display message:



ODBC-call failed
Microsoft[ODBC driver for Oracle][oracle]ora-01400 can not insert null into ("test"."test_name")(#1400)

This issue resulted form oracle linked table test_name is not allow now.
Do we have any way to close form with this message appears?

Thanks
new access

[June7]

Need to UNDO or CANCEL the record that was initiated by the DefaultValue. Not sure how that can be done because in my project I handle this quite differently.

Google: access exit form cancel new record

Does this help http://www.access-programmers.co.uk/...ad.php?t=73109

[newaccess]

thanks for your information. i used commend without save option

[June7]

Issue resolved?

[newaccess]

Yes. Thanks for help!