I have been trying to close a form, then delete it.. but it seems to not want to close
The object is to import an updated version of the form...
So I have an Update Button which calls another form..
In the form load of "update" form
Always says "Cannot delete while open"Code:DoEvents DoCmd.Close acForm, "Main" While (sysCmd(acSysCmdGetObjectState, acForm, "Main")<>0) DoEvents Wend Docmd.DeleteObject acForm, "Main"
even though it says its closed. Even if I wait with code pause.. says its open
Application.CurrentProjects.ALlForms("Main").IsLoaded is true even though syscmd says its closed...
Help!
I tired doing the update in a Module as well.. still says the form is open
I need to close the form.. delete it... import a new version.. and re-open it




Reply With Quote