Attempting to change the same data at the same time

[BLeslie88]

I was running an update query which was a work around dealing with an OLE object I needed to assign to the active table to allow changing rows colors on the fly based on an action taken. (BckGround bitmap assigned)

It was working fine until I made the table loading on a query instead of a table for my form. Now I get this error...

"Attempting to change the same data at the same time"

If I remove the order by.... and just use the table it works.

I can do a sort prior to loading the table which would resolve the issue...? Any other solutions? I know this isn't the cleanest method but this is a temp table used for one month before we start fresh next month with new data.

 

[Tanya]

I presume you are viewing your data in datasheet view. Have you thought of using the forms toolbar to sort your records?