I have several access 2K3 databases and we are getting ready to upgrade to 2K7 at work. One problem that I have encountered in my testing phase is that I have several buttons on different forms that when clicked will open another form and close the current form.
Example
-----
doCmd.OpenForm "frmSignInMenu" , acNormal
doCmd.Close acForm, "frmMainMen u", acSaveNo
-----
The problem that I am having is that when I click on some buttons that are coded the same way they work. Others do not. If I remove the doCmd.Close line it will open the other form just fine. If the line is left in there then access just closes completely.
Example
-----
doCmd.OpenForm "frmSignInMenu" , acNormal
doCmd.Close acForm, "frmMainMen u", acSaveNo
-----
The problem that I am having is that when I click on some buttons that are coded the same way they work. Others do not. If I remove the doCmd.Close line it will open the other form just fine. If the line is left in there then access just closes completely.