Replacing many values at once in a multiple values checkbox field.

[ConfusedDatabaseDesigner]

Hello,



I have a field on a form that allows users to select one or more different values. The values I set myself, and I made an error in naming one of them. I'd like to find all the records where this value was selected in that field and replace them with the correct version. I tried simply renaming the value but all the records that had already had the incorrectly named version stayed the same. Is there a way to fix this without going record by record and replacing the erroneously named value with the correct one? That would take forever.

Thanks!

[JoeM]

Is it the Field name you are trying to replace, or just the Field value for certain records?
If it is just the Field value, you can do that pretty easily using an Update Query.
Just create a Select Query that selects all the values you need to fix (by placing the incorrect value in the Criteria field for that field).
Then change to an Update Query, and place the correct value in the "Update To" line and run.

[ConfusedDatabaseDesigner]

Hi JoeM,

It's just the field value for certain records... that did the trick, thank you very much!