Could Not Find Record error

I'm using an Access database with Delphi front end.
I'm using ODBC to gain access to my Access database.
I have the following code,

   If tblDMC.Locate('CSDB;DMC_IDX',
DMAcquired.tblDMCISSNODMC_IDX.AsVariant]), [loCaseInsensitive]) Then
       tblDMCExcluded.AsBoolean := True;
      On E : Exception Do
       MessageDlg(E.Message, mtError, [mbOK], 0);

The Locate method returns true always (as the record is selected by the
When the code gets to the post an exception is raised and the message

"Could not find record"

I'm struggling with this, any opinions?


Email: j.demp...@LogisticsBusinessSystems.Ltd.Uk