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
Me!Operação.Enabled = False
Me!Operação.Locked = True
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?