Microsoft KB Archive/114863

= How to Update Other @ ... GET Fields While in a List Box =

Article ID: 114863

Article Last Modified on 10/15/2003

-

APPLIES TO


 * Microsoft Visual FoxPro 3.0 Standard Edition
 * Microsoft FoxPro 2.0

-



This article was previously published under Q114863



SUMMARY
This article describes how to update fields in a screen while a user is scrolling through a list box that is based on a database field (a "prompt field" in the Screen Builder in FoxPro 2.x for Windows).



FoxPro 2.x for Windows
When a list box is set up as a prompt field in the Screen Builder or is based on a POPUP defined with PROMPT FIELD, scrolling through the list box also moves the record pointer in the database. In order for other @ ... GET fields on the screen to be updated as the record pointer is moved, insert the following code in the WHEN clause of the list box: SHOW GETS RETURN The WHEN clause is reexecuted as the user moves through the list box, which allows this code to update those fields.

Visual FoxPro for Windows
In a form, use the following code for the list box's WHEN clause: THISFORM.REFRESH RETURN

Additional query words: VFoxWin FoxMac FoxDos FoxWin 2.50 2.50a 2.50b 2.50c 2.60 2.60a refresh show listbox

Keywords: KB114863

-

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

© Microsoft Corporation. All rights reserved.