Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. ACC2000: Status Bar Does Not Update After Opening a Pop-Up Form

ACC2000: Status Bar Does Not Update After Opening a Pop-Up Form

View products that this article applies to.

This article was previously published under Q303378
Novice: Requires knowledge of the user interface on single-user computers.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

↑ Back to the top

Symptoms

When you move through the controls on a form, the text on the status bar may not update.

↑ Back to the top

Cause

You have opened and closed a pop-up form from this form.

↑ Back to the top

Resolution

To resolve this issue, on the OnClose event of the pop-up form, open and close a form that is not a pop-up form. To do so, follow these steps:
1.Open your pop-up form in Design view.
2.Type the following code on the OnClose event of the form.
    'Turn off screen updating.
    DoCmd.Echo False

    'Open any other form that is not a pop-up form, and then close it.
    '<FormName> is the name of the form that you will open and close.
    DoCmd.OpenForm "<FormName>"    
    DoCmd.Close acForm, "<FormName>"

    'Turn on screen updating.
    DoCmd.Echo True
3.Close and then save the form.

↑ Back to the top

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

↑ Back to the top

More information

Steps to Reproduce the Behavior

CAUTION: If you follow the steps in this example, you modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and follow these steps on a copy of the database.

1.Open the sample database Northwind.mdb.
2.Close both the Startup form and the Main Switchboard form if they appear.
3.In the Database window, click Forms under Objects, and then click New.
4.In the New Form dialog box, click Autoform: Columnar, click Categories from the Choose the table or query where the data of the object comes from list, and then click OK.
5.On the File menu, click Save, and save the form as Form1.
6.Open the form in Design view.
7.Add a command button to the form with the following properties:
Caption:  Open Pop-Up
Status Bar Text:  Open Pop-Up
8.Put the following code on the OnClick event of the command button:
DoCmd.OpenForm "frmPopUp"
9.Close and then save the form.
10.In the Database window, click Forms under Objects, and then click New.
11.In the New Form dialog box, click Autoform: Columnar, click Products from the Choose the table or query where the data of the object comes from list, and then click OK.
12.Close and then save the form as frmPopUp.
13.Click Open and open the frmPopUp form in Design view and then set the pop-up property of the form to Yes.
14.Close and then save the form.
15.Open Form1.

Notice that the status bar text updates as you move through the controls.
16.Click Command to open the frmPopUp form.
17.Close the frmPopUp form to return to Form1.
18.Move through the controls on Form1.

Notice that the text on the status bar no longer updates.

↑ Back to the top

Keywords: KB303378, kbbug

↑ Back to the top

Article Info
Article ID : 303378
Revision : 2
Created on : 7/16/2004
Published on : 7/16/2004
Exists online : False
Views : 248