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


The information in this article applies to:

  • Microsoft Access 2000
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).

SYMPTOMS

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

CAUSE

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

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.

STATUS

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

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.
Modification Type:MinorLast Reviewed:7/16/2004
Keywords:kbbug KB303378
©2004 Microsoft Corporation. All rights reserved.