ACC1x: Control Still Appears on Page After GotoPage Action

• Microsoft Access versions 1.0, 1.1

SYMPTOMS

After the GotoPage macro action runs and a new page is displayed, the contents of the last control on the source page still appear on the new page.

CAUSE

The GotoPage macro action was run from a macro that is attached to the AfterUpdate property of a control.

RESOLUTION

Do not include a GotoPage macro action in a macro attached to the AfterUpdate property of a control. Instead, use the GotoPage action in a macro attached to the control's OnExit property.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Access versions 1.0 and 1.1. This problem no longer occurs in Microsoft Access version 2.0.

MORE INFORMATION

Steps to Reproduce Problem

1. Create a new macro with the following action, and then save it with the name GotoPage2:

         GotoPage
            PageNumber: 2
   
   

2. Create a new, unbound form.

3. Size the detail section of the form to be 4 inches tall.

4. Place a page break control in the form's detail section at the vertical 2-inch mark.

5. Place a combo box with the following properties in the upper half of the detail section, above the page break control:

         RowSourceType: Value list
         RowSource: 1;2;3;4
         AfterUpdate: GotoPage2
   

6. Place a text box in the lower half of the form's detail section, below the page break control.

7. Size the Form window so that only the upper half of the detail section is visible.

8. View the form in Form view.

9. Make a selection in the combo box.