Refire an Afterupdate Event

[jneirinckx]

Good morning,
We have a form where we enter asset data. Based on input I have an Afterupdate event fire to assign a category to the asset. This all works fine.

We now have changed the criteria in the calculation which again is fine but only is being applied to new records. Is there a way to refire/recalculate that Afterupdate event for exsisting records as it would be a lot of work to go back through about 1500 records and manually refire that event.

Thanks for any ideas/advice you can give.
Jerry

 

[pr2-eugin]

Hi Jerry, Well a cheeky way would be to call the AfterUpdate property manually through the FormCurrent method.. But you would have to open the form and navigate through all records.. you can also do that programmatically.. THIS IS NOT THE BEST OPTION.. but is one fix.. something like..

Privare Sub Form_Current
      Call field_Name_After_Update
End Sub

Then create a module, that will open the form and navigate till the end of the records.. something like..

Private Sub runCmd
 DoCmd.OpenForm "form_name", acNormal
 For i=0 to DCount("field_name","table_name")-1
     DoCmd.GoToRecord , , acNext
 Next
 DoCmd.Close acForm, "form_name"
End Sub

Hope this makes some sense.. Please restrain to this as the last solution, there might be better solutions..

 

[RainLover]

Running an Update query might be all you need.

 

[robertbwainwright]

Running an Update query might be all you need.

I would do what RainLover has suggestied and if you may need to requery your form to display the updates.

 

[missinglinq]

Using an Update Query would be the standard approach, here.

Linq ;0)>

 

[jneirinckx]

Thanks to everyone for their help. The code in the oncurrent event of the form did the job.

Thanks again.
Jerry