Updating one field with 90% value of other field one record at a time

[jman_66]

I need to update one field with 90% of the value from another field. I tried using a update query but that updates all records. I want to update a record at a time. This is so the user has the option of not doing the 90% update on particular records.

 

[AlanS]

You could use a Sub that cycles through the entire record set. For each record, display a MsgBox giving the user the choice, update the field (or not) depending on the user's response, and go on to the next record.

 

[Pat Hartman]

You can supply criteria so that the update query can selectively apply the updates.