Simple Loop problem

[MICHELE]

I am trying to update several records on a form at one time. My form shows in continuous view so that you can see all of the records on the screen at once. I am trying to update all of the PCODE fields at once with a control button. Can't I use some kind of loop? I've tried several ways but can never update more than one field at a time. Here's what I need to have repeat:


Me.PCODE.SetFocus
Me.PCODE = "P"
DoCmd.GoToRecord , acnextrec

I need for it to update all of the records that appear on the form

 

[Alexandre]

I believe a better approach would be to update your underlying records by running an update query, then refresh your form.