Thanks Eddie for the confirmation.

I originally had wriiten the Data Extraction bits months ago and recently changed my searching mecahanism so that no records could be returned. I had forgotten completely about the Navigated Event and was not looking there initially.

Hi Gerarld,

OK  Got this sorted.

I have code in the Navigated Event of the business object which uses one of the properties to fill a child table. I coded around this with an if MyBo.Count > 0 and it seems to have sorted it

I set up a brand new project with the same Business Object and issued the same command  (this.FilldataTable(locCommand) , which returns no records, but in this project, it behaves as expected, and even though no records are returned, no error message is given.

So there maybe is  a property of the BO, or something else on the form is casuing the error ????

I have changed a section of my code recently where I have a this.FillDataTable(loCommand);  Now , in some scenarios, this returns no records.  This has now caused an error saying currentRowIndex is out of range. I traced this to the get method in the Business Object column.

Why I am I geting this error and what do I need to do to avoid it. I realise it is something to do with zero records being returned