Hi Kevin.
Except as soon as I close the old alias, ThisForm.grdInvoice.Column2.Check1
>no longer exists. So now the 3rd column displays .F.Even when you set the grid's RecordSOurce temporarily to an empty string, the grid gets rebuilt.
You have 2 options here:
1. Create a parameterized view to use as the grid's RecordSOurce and requery it when you need to refresh the grid's contents.
2. Use a safe select to update the grid's recordSOurce (if you must use a cursor) like so:
SELECT ( This.RecordSOurce )
ZAP
SELECT SomeFields FROM SomeTable WHERE SomeCondition INTO CURSOR Fred NOFILTER
SELECT ( This.RecordSOurce )
APPEND FROM DBF( 'Fred' )
USE IN Fred
GO TOP IN ( This.RecordSource )
This.Refresh()