>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.
Rich,
Any single user could be "another user" :) There is a combobox and probably combobox has rowsourcetype = 1-Fields. It sounds to be the another user. Would you try the same with Rowsourcetype = SQL. BTW I'm just guessing w/o reproducing so try this only when you have some extra time.
Cetin