How to disable a control on After Update

[vX987]

Hello. I wanted to write a code for disabling a control if another control has a value in it.

For example, I have two controls, cntrlBlue & cntrlGreen that are not disabled on form load.

If I enter data into cntrlBlue then cntrolGreen is automatically disabled, vice versa if I enter data into cntrlGreen.

 

[RuralGuy]

Me.cntrlBlue.Enabled = False in the AfterUpdate event of cntrlGreen. You may wish to put this code inside of a test for valid input.