Experts:
I need some assistance with reviewing VBA and/or queries which currently result in a VBA error.
Background:
- Attached database contains several tables, queries, and two forms.
- Form "F50_BilletsToWorkingGroups" works great and allows me to add "billets to working groups".
- Once the form opens, I can assign billets/jobs to working groups A, B, C.
- Depending on the billet selection for each of the three working groups, the foreign keys are added to table "T10_JunctionTable_BWG".
- This process works flawlessly.
Additional Information:
- I need to replicate the same process for "billets to UJTLs" (never mind what UJTL stands for).
- So, I copied tables T10_JunctionTable_BWG and T11_WorkingGroups and named them T20_JunctionTable_BUJTL and T21_UJTL, respectively.
- I then populated some UJTLs (UniversalJointTaskList) into table T21_UJTL.
Reference Replacements:
- I went through a meticulous find/replace process (in ASCII program) and replaced any, e.g., "working group" references with, e.g., "UJTL".
- Below values were used to replace WG-related terms:
Queries:Code:[T21_UJTL] UJTLIDpk UniversalJointTaskList [T20_JunctionTable_BUJTL] UJTLIDfk BilletIDfk F51_BilletsToUJTL
- I replaced any of the working group references in all three queries (Q51A_BilletsToUJTL; Q51B_BilletsToUJTL; Q51C_BilletsToUJTL).
- For testing purposes, I then executed and compared results between, e.g., "Q50A_BilletsToWorkingGroups" and "Q51A_BilletsToUJTL".
- The query structures (in design view) appear to the same and the queries also returned UJTL-related info vs. WG-related info.
- So far so good (I believe)... now onto the form... and this is where I need some help with.
Form:
- I copied form "F50_BilletsToWorkingGroups" and then named it "F51_BilletsToUJTL".
- Afterwards, I again went through the find/replace for (I believe) all WG-related references to UJTL references.
- I did this for the following:
* Drop-down combo data source;
* Drop-down event (and all associated VBA)
* Query reference in left listbox
* SQL update in right listbox
Ultimately, I did this whole "thing" twice and twice am I ending up with the same VBA error when opening the form "F51_BilletsToUJTL".
My question:
What am I still missing which prevents "F51_BilletsToUJTL" to work in the same fashion as form "F50_BilletsToWorkingGroups"?
Any specific references would be truly appreciated!!
Thank you in advance,
EEH