Solved ComboBox Dropdown List Problem

[Sarah.M]

Hi, Plz note, My VBA is blocked by IT for security reason (Cybersecurity).
I can use only Expression builder, Macros, Queries, Tables, Forms and Reports only.
------------------------------------------------
User 1 Join to Level 1 and Level 2 and
Level 1 has frm1 and frm2
Level 2 has frm3 and frm4

In LogIn form I have ComboUserID cascading ComboFrms
but if I pick from list frm3 or frm4 it does not accepted why?
If I pick frm4 he give me frm1 instead
If I pick frm5 he give me frm3 instead

Plz help me what do you think the problem is?
Sample Attached

 

[Sarah.M]

I think I need to put conjuction table instead of 1 to M relationship

 

[Sarah.M]

Suggestions plz

 

[theDBguy]

but if I pick from list frm3 or frm4 it does not accepted why?

The reason for that is because your bound column is not unique. Try changing the Bound Column to 2.

 

[Sarah.M]

@Pat Hartman @theDBguy
Awesome!
Thanks it works now, Unique was my problem

 

[theDBguy]

@Pat Hartman @theDBguy
Awesome!
Thanks it works now, Unique was my problem

Congratulations! Glad to hear you got it sorted out. Both @Pat Hartman and I were happy to assist. Good luck with your project.