CODEWITHSUNDEEP
ms-accesscompiler-errorsvba
user2093441
user2093441

Reputation: 41

VBA - "Compile Error: Method or data member not found"

I have been developing an Access form to operate as a frontend for a SQL database. I have been working with a developer, and they added the following VBA code to our main form:

Private Sub Form_Current()
    If Me.NewRecord = True Then
        Me.Client_Name.Enabled = True
        Me.SSN.Enabled = True
        Me.DOB.Enabled = True
        Me.Prob_Fee.Enabled = True
        Me.Settle_Atty_Amt.Enabled = True
        Me.Settle_Date.Enabled = True
        Me.Final_Date.Enabled = True
    Else
        Me.Client_Name.Locked = True
        Me.SSN.Locked = True
        Me.DOB.Locked = True
        Me.Prob_Fee.Locked = True
        Me.Settle_Atty_Amt.Locked = True
        Me.Settle_Date.Locked = True
        Me.Final_Date.Locked = True
    End If
End Sub

When I try to add a new variable to this statement Me.Case_ID.Locked = True, the following error is returned:

Compile Error: Method or data member not found

I'm not sure where to go from here.

Upvotes: 4

Views: 43826

Answers (1)

Fionnuala
Fionnuala

Reputation: 91336

Make sure that you are referring to the name of the control that you just added. It may not be the same as the field / column contained. On the 'Other' tab of the property sheet, you will find Name, that is the property you need. It is often different from the name of the control contained.

control name

Upvotes: 5

Related Questions