When changes are made...

[ahuvas]

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?

 

[Dennisk]

create an update query

 

[ahuvas]

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