Modal form with cancel

[rewdee]

I use to know how to do this but I've forgotten.
=================================================
Say I create a bound modal form and I call the form like this:

DoCmd.OpenForm "myform", acNormal, , , acFormAdd, acDialog

However, what if the user wants to cancel there entry (eg. say the form has Ok and Cancel Command buttons. How do I cancel the post (sorry update in Access)?

Thanks,
Rewdee

 

[mp9]

A couple of things you could try:

Either...

Set the Cancel property of your cancel button to True

Or...

In your cancel button's OnClick event put something like Me.Undo

Hope thiw helps.

http://www22.brinkster.com/accessory/