Solved Combo Selection Based on Another Combo (1 Viewer)

[Weekleyba]

This seems easy but for some reason I cannot get this work.
What am I doing wrong here? (I attached the db also.)

Here's the two combos.
I want the selection of the Chair Person (cboChairPerson1) to be based of the Tribe (cboTribe1).

cboTribe1 row source is the follow select query

cboChairPerson1 row source is the following select query.

The NOFA_Create_F row source is NOFA_Q

 

[theDBguy]

Hi. Can't download your file right now, but maybe what you're missing is a requery of the second combobox in the AfterUpdate of the first one.
Sent from phone...

 

[MajP]

From your image you are referencing the MainForm and should be Nofa_Creat_F.

 

[Weekleyba]

MajP, Thank you!!!
For some reason, I just could not see that.
It works perfectly now.
Appreciate your time.

 

[MajP]

Those type of issues are hard to see when you are working on it. You can stare at it and do not notice. Takes as fresh set of eyes. Good luck.