Hello everybody!

I have a problem with a project.

This project has a form, in which i fill data.

The first Control in the form is a personal ID, with the name "ID Oper B". I want this control to be disabled after I enter data in it.
For that porpuse, i created a OnLostFocus Event, with the Code Builder. The procedure is as follows:

Private Sub ID_Oper_B_LostFocus()
        Me!ID_Oper_B.Enabled = False
End Sub

This procedure does not work: As I fill the data in this control and move focus to the next control, the following message appears:

run time error 2465
Microsoft Office Access can't find the field 'ID_Oper_B' referred to in your expression.

What should I do?

I also want the next Field, named "Operação", to be disabled and locked until it's previous field (ID_Oper_B) has a certain value ("joaquim"). Having that in mind, I created the followin event procedure using the code buider:

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

I also get an error message because of this procedure: exactly the same as above.

What am i doing wrong? Can anybody help me? I would appreciate it!

Thanks

Luís

See my other post.

Also, on the first issue, you will need to do this:

Private Sub MyForm_OnCurrent()
If IsNull(Me.ID_Oper_B) Or Me.ID_Oper_B = "" Then
   Me.ID_Oper_B.Enabled = True
Else
   Me.ID_Oper_B.Enabled = False
End If

End Sub

This will keep someone from entering data when they first open the form but the field was filled in previously.

You will also want to put this on the AfterUpdate event for the form.

Is this helping?

mmcdonal

Look it up at: http://wrox.books24x7.com