Attachment 33453
I have been posting my Access DB problems in this forum from the past two months and I am very thankful to people who tried to help me. This is a the next stage of my previous thread https://www.accessforums.net/showthread.php?t=71072.
But I will give a brief introduction. i have a form "Create New Machine" with four cascading listboxes with previous data already available. I am adding a new record say "New Machine" in the first listbox and inserting the existing data into it.
Some information from the image attached:
- Machine Sub System A & B belong to Machine System A.
- Machine Sub System C & D belong to Machine System B.
- Components A & B belong to Machine Sub System A.
- Components C & D belong to Machine Sub System B.
- Components E & F belong to Machine Sub System C.
- Components G & H belong to Machine Sub System D.
Now there is a duplication of records in the fourth listbox from selection in third listbox, and also there is pattern.
Components A & B and Components E & F from Machine Sub System A and Machine Sub System C respectively are showing duplicates.
Where as Components C & D and Components G & H from Machine Sub System B and Machine Sub System D respectively are working correctly.
I have also attached the main part of the code.
I am not able to solve the issue. Any help will be greatly appreciated.
Please ignore the Duplicate Code and refer to the Updated Code because I feel that there is a problem with the Looping of the If statement that was not captured in the first image.
Thank you in advance.
Regards