Trying to figure out Intellisense and/or underlying problem.

[Stang70Fastback]

Hey guys, I've got a simple question.

I have two forms - both of which are subforms on another form. Each of them is linked to a different table. The master field/child fields are linked to the main form, and those fields do not have controls on the subform as that is unnecessary for me.

On one form, if I'm using VBA and type "Me.", Intellisense gives me the option to select the fields from the underlying table.

On the other form, if I type the same "Me.", Intellisense does not give me that option. If I manually refer to one of the table's underlying fields that is not a control, then the code fails as it cannot find what I am referencing.

I am confused because both of these forms are fundamentally the same, but only one of them seems to allow me to reference the fields in the underlying table. What am I missing?

I've had this issue in other forms I've worked on in the past but it never became a problem before. Sometimes I can use Me. and then refer to any field in the RecordSource, but other times I can't, and I have to create a hidden control with that field as its source in order to refer to it.

 

[Rx_]

http://books.google.com/books?id=NafXqquUxbsC&pg=PA246&lpg=PA246&dq=intellisense+access+subform+vba&source=bl&ots=6FCB6kFAo7&sig=RSLkRXN6ulJ0D2NDCKIKQNXOPG8&hl=en&sa=X&ei=Po5bVNnbEMn2yQSpqYCwCg&ved=0CCYQ6AEwAQ#v=onepage&q=intellisense%20access%20subform%20vba&f=false
Three Pages in this manual (if the link works)
Start with All About ME
Followed by the "tricky part of Sub Forms"

 

[Stang70Fastback]

Okay, so I see that I should be using Me!fieldname rather than Me.fieldname to reference what I am looking for (to be clear, the code is running within the subform, so I'm not actually needing to reference another form. I probably shouldn't have mentioned the subforms at all to avoid confusion.)

So my question now becomes, how come on one form I CAN use Me.fieldname, whereas on the other form, I can't? This inconsistency is really bothering me.

 

[JHB]

I think I've never observed what you're writing about, could you upload a sample database? And exact info about how to reproduce what you write.