Form&Subform Undo/Rollback

[GJT]

I have found
this link referring to Form - Subform rollbacks.

this is fine when working with a standard Form / Subform setup, my database however is replicated and when I run this code to enable me to rollback the changes,I get :

Error code : 3666
You cannot modify the replication system object 's_Generation'

If only I could get aorund this bug - then I'll be home and dry......

Has anyone overcome this problem before......?????

 

[GJT]

FYI

I have managed to get around this problem by interrogating the field type using Instr. If the field name contains 's_' then this field is a replication field and MAY NOT be updated/modified.

Hence:

If (InStr(1, TempRS(i).Name, "s_")) = 0 Then FormRS(TempRS(i).Name) = TempRS(i)

Rollback then works exactly as it should!