End satement not working

[hmstoo44dd]

Access 2002:

I am trying to use the end statement in the form load event to stop execution of all code/modules if the user id is not listed in a table. However, it just stops execution of the code in the load event and loads the form. I've never had this problem before in other VBA development environments. Any ideas?

 

[Kleinen]

If you want to close the form you should use

Unload Me

or

DoCmd.Close

 

[JerryKlmns]

A DoCmd.Quit will shut the door!

 

[SeeThru]

Rather than END, try EXIT sub

 

[hmstoo44dd]

Thanks everyone. DoCmd.Quit was exactly what I was looking for.