Listbox

[skydivetom]

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

[davegri]

Everywhere in the code you have Me.EventIDpk, change it to [EventIDpk].

[skydivetom]

davegri:

Thank you for the reply...

I replaced the instances in the VBA... I still get the same error though. Did it work for you? If so, could you pls post your version (or VBA)?

Also, how come it's working fine in v01 (w/o making the VBA change)?

Thank you in advance,
EEH

[davegri]

Listbox -- Events davegri v02.mdb
This works for me in 32 bit Access.
The ME. prefix refers to a control on the form. There is no control on the form named TeamIDpk or EventIDpk, so I don't know how it works in one but not the other This has always been an error in my recollection. Maybe has something to do with early .mdb files.
The brackets let the reference see the data name in the form recordsource.

[skydivetom]

Davegri:

Perfect!! I did NOT add the brackets [] when replacing Me.EventIDpk to [EventIDpk]. You included them... I overlooked them.

Again, thank you for helping me out. I really appreciate it.

Thanks,
EEH