Microsoft KB Archive/136671

= DOCERR: "Refreshing One-to-Many Display" Help Topic Incomplete =

Article ID: 136671

Article Last Modified on 2/15/2000

-

APPLIES TO


 * Microsoft Visual FoxPro 3.0 Standard Edition

-



This article was previously published under Q136671



SUMMARY
The "Refreshing a One-To-Many Display Based on a List Value" Help file topic is incomplete. The directions given work correctly if the many display is a grid but cause sporadic behavior or errors if the many display is a list box.



MORE INFORMATION
If a list box is used for the child (many) display, upon making a selection from the parent (one), the list box will not reflect the child (many) records unless it gets the focus. To give the list box the focus, you need to click it with the mouse or press the TAB key to move to it.

Once the list box has received the initial focus, any subsequent parent selections cause the list box to display the appropriate child records.

If a "ThisForm.Refresh" is added to the parent object InterActive Change method, a "Record is Out of Range" error occurs after making a few parent object selections.

To have the child object behave correctly, the second list box must be requeried in order to properly display the new information.

In Step 5 of the Help topic, after the REQUERY command, add this line: ThisForm.{ListBox2 name}.Requery

Additional query words: VFoxWin

Keywords: KB136671

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.