PRA: Mouse Pointer Blinks Between Hourglass and Pointer (2.0)

Article ID: Q131940
Creation Date: 25-JUN-1995
Revision Date: 19-SEP-1996

The information in this article applies to:

Microsoft Access version 2.0

SYMPTOMS

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

The mouse pointer blinks between an hourglass and a pointer when you make a selection from a combo box or a list box on a main form that contains several subforms.

CAUSE

The LinkMasterFields property of one of the subforms is set to a calculated control that refers to a combo box or a list box's Column property.

RESOLUTION

To work around this problem, make the control unbound and set its value in the combo box's AfterUpdate event procedure. To do so, follow these steps:

Open the sample database NWIND.MDB.

Open the Customers And Orders form in Design view.

Add a combo box to the main form and set the control's properties as follows:

      Name: Customer Pick List
      RowSource: Customers
      ColumnCount: 2
      ColumnWidths: 0 in; 1 in
      BoundColumn: 1

Set the combo box's AfterUpdate property to the following event procedure:

      Sub Customer_Pick_List_AfterUpdate ()
        Me![LinkMain] = Me![Customer Pick List].Column(0)
      End Sub

Add a text box to the main form and set the control's properties as follows:
```
      Name: LinkMain
      Visible: No
```
Set the Customers And Orders Subform form's LinkMasterFields property as follows:
```
      LinkMasterFields: LinkMain
```
Open the Customers And Orders form in Form view and select a value from the combo box. Note that the mouse pointer does not blink from an hourglass to a pointer.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Access version 2.0. We are researching this problem and will post new information here in the Microsoft Access Knowledge Base it becomes available.

MORE INFORMATION

Steps to Reproduce Problem

Open the sample database NWIND.MDB.

Open the Customers And Orders form in Design view.

Add a combo box to the main form and set the control's properties as follows:

      Name: Customer Pick List
      RowSource: Customers
      ColumnCount: 2
      ColumnWidths: 0 in; 1 in
      BoundColumn: 1

Add a text box to the main form and set the control's properties as follows:

      Name: LinkMain
      ControlSource: =[Customer Pick List].[Column](0)
      Visible: No

Set the Customers And Orders Subform form's LinkMasterFields property as follows:
```
      LinkMasterFields: LinkMain
```
Open the Customers And Orders form in Form view and select a value from the combo box. Note that the mouse pointer blinks between an hourglass and a pointer.

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.