Colin,

The values were assigned properly and I was looking at the correct work area and I did do a refresh. The problem with REQUERY() is that it requeries all records and not just the one you are sitting on. It throws out the current cursor and builds a new one.

I am looking at using a parameterized view and then getting the Key ID value from the Stored Procedure to use to Requery(). This way I have only One View. Then when I got to a list tab to view all Records I can then just issue:

cID = ''
SELECT fields WHERE ID = ?cID

Then when I leave the Grid tab I can then do:

cID = View.ID
Requery()
Refresh()


I think this might work.