Lock a field in a form until other field is filled in?

[manzier]

Hi all,

I'm trying to figure out a way to lock Field1 until Field2 has been populated. However, I'm very new at access and I'm not sure how to go about doing this.

Current code that's not working:

Private Sub Field1_BeforeUpdate(Cancel As Integer)
If Me.Field2 Is Null Then Me.Field1.Enabled = False
Else Me.Field1.Enabled = True
End Sub

Please advise!

 

[alansidman]

Try putting your code in the OnCurrent Event instead of the BeforeUpdate Event

 

[strive4peace]

and also the AfterUpdate event of 'field2', which, when referring to forms, would be 'controlname2'

WHERE
controlname2 is the Name of the control containing field2