I have a form with multiple subforms. The ADO connection is opened to populate the fields in the form and subforms and closed afterwards so it does not slow down the servers. In Access 2003, it works fine, but 2007 causes all the subforms to unload when the connection tries to close.
To close...