I recently changed the code to a case statement which recoded a value into a new field

i.e.

Case = 1
Me.Field2 = 2

and so on...

However the old data would not reflect this change as the Me.Field2 value had already been created.

Short of opening each form, changing a number closing it and then changing it back to original value, it there any way to get the database to rerun all the code in the background essentially?

create an update query

Thanks, There is a good article from Miicrosoft - I will check it out.