Missing Field in intellisense dropdown

[benchpolo]

Private Sub Frame219_AfterUpdate()
     If Me.Frame219.Value = 1 Then               Me.wasextension2.Value = "Y"
End Sub
 

I have a table field in SQL called extension2, and it is linked via ODBC connection in Access 2010. When I compile my code i get an error "Method or data member not found" error, but I can see field "wasextension2" in my link tables. Is there a configuration that i need to check?
Thanks.

[beacon]

Have you tried dropping the "Me.wasextension2.Value = 'Y'" to the next line and adding an "End If" on the line after so it looks like this:

Private Sub Frame219_AfterUpdate() 
     If Me.Frame219.Value = 1 Then
          Me.wasextension2.Value = "Y"
     End If
End Sub 
 

I'm not sure if this will make any difference, but it's worth a shot.

beacon

[TheSmileyCoder]

First thing to check is that the field is actually also pulled into your record source for the form you are using.

If that doesn't work I would suggest you try to decompile, and then recompile your database.