Change of fieldname results in VBA error

[skydivetom]

Experts:


I need some help with identifying an error (in VBA) which is due based on **changing a fieldname**.




Attached are the following documents:
- Database "Version01" -- this version works w/o issues (before change of fieldname)
- Database "Version02" -- this is a replica of v01 but w/ the updated fieldname... resulting in a VBA error
- PDF "Summary" -- this document includes some screenshots and highlights the differences between v01 and v02


As indicated in the PDF, I simply changed the fieldname in table "T00_JunctionTable_CPR" + 3 instances in the VBA (of subform).
Unfortunately (see illustration in the PDF) v02 results in a VBA error. Does anyone know where/what else needs to be updated so that v02 works just like v01?


Thank you,
EEH

[June7]

My question is "Why does Ver 1 work?" Note that in Ver 1 a reference of Me.RoleIDfk will fail. I have no idea how Ver 1 is finding Me.StaffMemberIDfk and listing it in intellisense even though it does not show in form Properties Sheet list. There is no control with this name just as there is no control named RoleIDfk.

However, use of ! does work in Ver 2: Me!ContactIDfk

[skydivetom]

June7 -- THOUSAND THANKS!!!
I would have never thought to change the "." with an "!". You're absolutely right... why would it work in v01 but not in v02. Anyhow, you solved the mystery!
Thank you again,
Tom

[June7]

Code should reference control name, not the field: Me.cbo_LastName