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

 

[Pat Hartman]

You seem to be using table level lookups which experts do not recommend. They obfuscate the actual value in the table and don't work in all situations. They are a crutch for someone who doesn't know how to make a join.

Also, I would never use combos on a login form.

Remove the table level lookups so we can see what the IDs are. Also tell us what the bound field is for the second combo. Combos do NOT work when the bound column is not unique and looking at your pictures, there are duplicates so there is no way for Access to know which frm1 to choose. That's why you end up with the first instance of form1.

To summarize, If you are going to use a junction table in a combo, it needs an autonumber primary key in addition to the unique index on the two foreign keys. The combo needs to be bound to the autonumber.

 

[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.