The Code below is from the "AfterRowColumnChange" event of a grid.
When using up and down arrows within the IndivKey column the textboxes on the pageframe below the grid *ARE* refreshed with the appropriate data from the view, which gets it's parameter from IndivKey column of the newly selected row. However, if the operator scrolls up and down the grid in any other column except IndivKey, the textboxes on the pageframe do NOT update, even though the grid row text changes color from black to red, proving that this method fires and the officersrecno value is correct. The IndivKey column is not the key field. The key field is called keyfld, and is the child key in a one-to-many relationship. I am using these specific refresh statements (using VFP6.0) because the ThisForm.Page3.Refresh() didn't work (actually it works the same way) either.
Jerry
LOCAL nIndivKey
ThisForm.Officersrecno = RECNO()
nIndivKey = 0
temp = This.Column14.txtIndivKey.Value
IF VARTYPE(temp) = "N"
nIndivKey = temp
ELSE
nIndivKey = INT(VAL(temp))
ENDIF
THISFORM.LOCKSCREEN = .T.
=REQUERY("lv_indivadr")
WITH This.Parent
.txtWholename.Refresh()
.txtAddress.Refresh()
.txtAddress2.Refresh()
.txtCity.Refresh()
.txtState.Refresh()
.txtZip.Refresh()
.XtxtCountry.Refresh()
.txtSSN.Refresh()
.txtDOB.Refresh()
.txtHomefone.Refresh()
.txtWorkfone.Refresh()
ENDWITH
THISFORM.LOCKSCREEN = .F.
Nebraska Dept of Revenue