Access coding

Obidombie

New member
Local time
Today, 00:26
Joined
Aug 4, 2013
Messages
2
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?
 
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
 
Thank you Boss, I will try asap.
 

Users who are viewing this thread

Back
Top Bottom