Refresh the Left Navigation Bar to show a created table

Posted on 2007-08-03
Last Modified: 2013-11-05
I am making a new table using a CurrentDB.Execute command.  I want to be able to view it on the left navigation bar as soon as I make it, but can not find a way to refresh the navigation bar.  
Question by:VoodooFrog
    LVL 33

    Expert Comment

    by:Mike Eghtebas
    re:> refresh the navigation bar

    I don't understand whay you mean by "refresh the navigation bar"

    But if you want to refresh a form, include one of these after CurrentDB.Execute ...

    Me.Requery    'if local

    Me.Subform1.Form.Requery    'if local

    Forms.Form1.Recordsource = Forms.Form1.Recordsource

    LVL 119

    Accepted Solution

    not sure about A2007, but in A2003 you can use


    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    This article explains all about SQL Server Piecemeal Restore with examples in step by step manner.
    Creating and Managing Databases with phpMyAdmin in cPanel.
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now