title: How do I re-populate the navigation pane in microsoft access 365 through VBA?
body: <p>I just recently upgraded from Microsoft Access 2010 to Microsoft Access 365.  Me along with a handful of other users need to navigate a Microsoft Access instance and easily change databases (there's 150+ on the server).  In Microsoft Access 2010, it was easy.  Just go into File, Connection Settings, Change database name, and the navigation pane populates with the corresponding stored procedures, tables, etc.  Now, it's not as easy.  This time, when the instance opens, I have a form that opens up that contains a combo box.  This combo box contains all the database names on the server, based on SQL initializations in VBA.  (&quot;Select name from sys.sysdatabases&quot;).</p>
  <p>So my question:  Based on database name selection, how can I populate the navigation pane with the tables, stored procedures, etc. that the SQL database has?</p>