Access coding

[Obidombie]

I am currently designing a database, and there is a field for date of birth, and other for just Age. I want to make it such a way that whenever date of birth is entered, the field for age should be blocked or, if i enter an Age, the field for Date of birth too should be blocked.
Is any body have an idea of how the code should be written?

 

[ypma]

This is one way :
In the AfterUpdate event .


Private Sub DOB_AfterUpdate()
Me.Age.Locked = True
End Sub

Then the same for the Age.

Fellow user not a programmer

 

[Obidombie]

Thank you Boss, I will try asap.