Custom OpenForm code – Close and open your form
One of the major issues with DoCmd.OpenForm is it doesn't close the form before opening it again. This can lead to unexpected behavior of your application, so of course I created my own open form code: