ACC2: Navigation Buttons Not Enabled, Disabled Correctly

• Microsoft Access version 2.0

SYMPTOMS

Moderate: Requires basic macro, coding, and interoperability skills.

When you move between a main form and a subform, the navigation buttons on a form's toolbar are not enabled and disabled correctly.

CAUSE

The screen is not being refreshed correctly.

RESOLUTION

Press the F9 key or requery the form to refresh the screen.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Access version 2.0. This problem no longer occurs in Microsoft Access version 7.0.

MORE INFORMATION

Steps to Reproduce Problem

CAUTION: Following the steps in this example will modify the sample database NWIND.MDB. You may want to back up the NWIND.MDB file, or perform these steps on a copy of the NWIND database.

1. Open the sample database NWIND.MDB

2. Open the Orders form in Form view.

3. Make sure the Orders form toolbar is visible. If it is not, choose Toolbars from the View menu, select Form View, choose the Show button, then choose Close.

4. From the View menu, choose Toolbars. Choose the Customize button, then select Records in the Categories box. Drag the Previous Record and Next Record buttons from the Buttons box to the form's toolbar. Choose Close.

5. Note that the Previous Record button is disabled, since the first record is the current record (there is no previous record).

6. Click the Next Record button. Note that the second record becomes the current record, and that the Previous Record button is enabled.

7. Select the first record in the subform. Note that the Previous Record button is still enabled, even though there is no previous record in the subform.

8. Select the second record in the subform, and then select the first record in the subform again. Note that the Previous Record button is now disabled.

9. Click anywhere in the main form. Although the second record is the current record, the Previous Record button still appears disabled. Note that you can use the Previous Record button even though it appears disabled.

REFERENCES

Microsoft Access "User's Guide," version 2.0, Appendix B, "Working with Toolbars," pages 711-727