I have a continuous form and I would like to cycle through all of the records on the form and perform a calculation. The calcuation is in a routine and then sets the bound text box on the form to the result
On Error Resume Next
Do While Not Me.Recordset.EOF
The movenext line causes a problem. It warns that the record has been changed by another user and I have to click on save record in order to continue. Any ideas how to get around this?
Try that and see what happens. Oh, I found a better way to avoid suppress warning messages. Rather than doing the (SetWarnings/True/False) thingy in my code I have: CurrentDB.Execute "My Special Query here"