I am using ms access 2007 after update property where the user can change the value on Field A and it impact the value on field B, but if field A is null then I want the user to be able to change field B. Below is the code I am using but it isn’t working.
If Me.Filed A Is Null Then
Me.Field B (this would be whatever the user wants to type in) This is where i get my error
If Me.Filed A Is Not Null Then
Me.Field B = Me.Field C