Ado, Vsflexgrid, Databinding and Filter

[PascalTheroux]

I have an ADO recordset with a field name STATUS.
Some records have it set to "Y" and others to "N".

I also have 2 vsflexgrid on the screen.
I want the first to display the records with the "Y" STATUS and the second one to display the "N" STATUS.

I want to be able to pass a record from one grid to another by editing the cell STATUS on the grid but I have problem mixing the Databinding option with the filter.
What is the best way to do this with the less possible line of code.

 

[BKtechie]

Try creating 2 Ado recordsets to populate each control.