ACC1x: Control Still Appears on Page After GotoPage Action

ID: Q104825

The information in this article applies to:

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

Create a new macro with the following action, and then save it with the name GotoPage2:
```
      GotoPage
         PageNumber: 2 
```

Create a new, unbound form.

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

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

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 
```

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

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

View the form in Form view.

Make a selection in the combo box.

The form will advance to page 2, and the text box will be selected, as it should be. However, the combo box will still be visible on the page and may overlap the text box.

Additional query words: gotocontrol ghost

Keywords : kbprg McrOthr
Version : 1.0 1.1
Platform : WINDOWS
Issue type : kbbug