GRID PROBLEM
I've been debugging an Error 109 in a form that has a Grid that has fields in it that are changed using a Replace command after a user changes a ComboBox value. On occassion I get a "Record In Use By Another User" and since I am using a Local View my computer is lying to me!
Well it seems to be a timing issue. I looked up some threads posted elsewhere. Bonnie was getting this error in a grid with a checkbox. That solution won't work because I am SCANning down all of the records in the local view and changing a value with REPLACE.
GRID SOLUTION :-)
I took and detached the ControlSource from the column that I was changing prior to doing the SCAN/REPLACE and then reconnect at the end of the SCAN loop and it seems to have permanantly gone away.
I have seen this same problem cropping up in some of my other apps but have never been able to pin it down. I know this happens sometimes in an APPEND BLANK or DELETE in a GRID as well.
Anyone have any comments or other hints. I think I have this one solved. I thought I would share my testing to help alleviate anyone else going through the same Frustation with hard to reproduce code.