Hello!

How is everybody?

I have a problem with an Access Project:
My project has a form. In that form, I have several controls (fields to fill data in). I need to disable one control until another control (operator ID) is filled. I also need to disable the operator ID control as soon as it has been filled.
I am working with Access 2003
For the 1 problem i tried to create a BeforeUpdateEvent, then a CodeBuilder, with an IF/Then transaction:
Private Sub Operação_BeforeUpdate(Cancel As Integer)
        If Me!ID_Oper_B = "joaquim" Then
        Me!Operação.Enabled = True
        Me!Operação.Locked = False
    Else
        Me!Operação.Enabled = False
        Me!Operação.Locked = True
        End If
End Sub

Can you tell me what's wrong with this transaction? Should I try something else?

For the second problem, i am thinking about doing an AfterUpdateEvent which Disables the control after it has been filled. how do I do that?

Can anybody help me?

Thanks!

Luís