Row cannot be located for updating

[Ramya1]

I have an application with multiple access. On certain items in the grid, when I pull the item up and try to modify the item information, it gives this error "Row cannot be located for updating. Some values may have been changed since it was last read."
It is displaying as Database Error and we are unable to proceed when the popup comes up and locks everything up.

Any suggestions or explanations on how and why the error occurs and steps to solve the error "Row cannot be located for updating" is much appreciated.

Thanks.
Ramya.

 

[Chad123]

Hey,

What you will need to do is requery your recordset. This will allow your recordset to grab the most recent data. I tend to do this at the beginning of each function when I have a global recordset open that is used in many places...It is easy, quick and adds database integrity to your app... The expression is below:

RS.Requery (where RS is the name of your recordset)

Hope this helps,
Chad