Cancelling the opening of a form?

[Guest]

I'm sure this is an easy one: I have a handler in my Form_Open that checks
for valid inputs. In the case of invalid ones, I'd like to put up an error,
and then NOT open the form.

DoCmd.Close closes the entire app, I assume because the form is not yet
open. Is there a trick to this?

Maury

 

[Douglas J Steele]

Simply put Cancel = True in the form's Open event if you don't want it to
open.

 

[Guest]

Simply put Cancel = True in the form's Open event if you don't want it to
open.

Thanks, I knew it would be simple.

Maury