Experts:
I need some help w/ locating a required fieldname update for a database using two listboxes.
Background:
- Attached are two (2) databases. v02 is a replica of v01 except I changed only one fieldname.
- v01 works great; however, given the change of the fieldname (i.e., from v01's [TeamIDpk] in table "00_tblEvent" to v02's [EventIDpk] in table "00_tblEvent"), the form "frmEventAssignments" results now in an error upon opening.
- The data is 100% arbitary (i.e., actor's names and event names).
Process (in v01):
- Open the form
- Select any of the three events from the drop-down menu
- Use the listboxes to assign/remove names from the events
Changes I made:
- Again, v01 works great but has the fieldname referencing "TeamIDpk" throughout the database. That is inconsistent given that I'm assigning members to events (not teams).
- Thus, in v02 I used the "Find & Replace" to replace any instance -- well, I should say I believe I replaced any instance equal to "TeamIDpk" with "EventIDpk" -- through all objects (tables, queries, forms, combo box, list boxes, as well as the VBA).
Dilemma:
- I have tried updating v02 multiple times... each time, however, I end up w/ the same error indicating a "Compile Error - Method or data member not found".
- Each time I ended up going back to v01 and replicated into v02 and then and changed all instances of "TeamIDpk" with "EventIDpk". Yet, each time, I come up w/ the same error when opening the form.
Does anyone know what's the missing (hidden) property which still requires an update to "TeamIDpk" and thus needs to be changed to "EventIDpk"?
Thank you,
EEH