By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,483 Members | 1,909 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,483 IT Pros & Developers. It's quick & easy.

Missing Field in intellisense dropdown

benchpolo
100+
P: 142
Expand|Select|Wrap|Line Numbers
  1. Private Sub Frame219_AfterUpdate()
  2.      If Me.Frame219.Value = 1 Then               Me.wasextension2.Value = "Y"
  3. End Sub
  4.  
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.
Jun 15 '12 #1
Share this Question
Share on Google+
2 Replies


beacon
100+
P: 579
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:

Expand|Select|Wrap|Line Numbers
  1. Private Sub Frame219_AfterUpdate() 
  2.      If Me.Frame219.Value = 1 Then
  3.           Me.wasextension2.Value = "Y"
  4.      End If
  5. End Sub 
  6.  
I'm not sure if this will make any difference, but it's worth a shot.

beacon
Jun 15 '12 #2

TheSmileyCoder
Expert Mod 100+
P: 2,321
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.
Jun 18 '12 #3

Post your reply

Sign in to post your reply or Sign up for a free account.