change values in continuous form's rows

[thewiseguy]

hi there,

i have a continuous form called [subfrmDIAGNOSIS] with one of the fields called [ProtocolNo].

Now i'm trying to use a bit of VBA that will change [ProtocolNo] to a different value if requested by the user and this works fine for the current row.

However, if there are rows already completed, they will remain in the form's table with the old value, as expected because they are now saved records.

Is there a way of changing [ProtocolNo] for all the rows in the continuous form without affecting any older records stored in the corresponding table?

 

[llkhoutx]

Use an update query with appropriate criteria, then requery the form.