J
jerryb123
I am trying to create a form with three cascading combo boxes, for Sales Rep,
Agent and Subagent. Each Sales Rep has certain Agents assigned to them, and
each Agent has certain Subagents. When a user selects Sales Rep in the first
combo box, I want the second to show only those Agents that are assigned to
them, and when they select an Agent, I want the third to show only the
Subagents that are assigned to them.
I posted a few days ago, and people told me how to set the Row Sources, and
how to Requery and set values to null if users changed their minds and
selected different values in the first two combo boxes. My problem, though,
is that when I pull down the later combo boxes, the values appear, but when I
select them, they don't actually show up in the combo box. The combo boxes
stay blank. Has anybody seen this?
Agent and Subagent. Each Sales Rep has certain Agents assigned to them, and
each Agent has certain Subagents. When a user selects Sales Rep in the first
combo box, I want the second to show only those Agents that are assigned to
them, and when they select an Agent, I want the third to show only the
Subagents that are assigned to them.
I posted a few days ago, and people told me how to set the Row Sources, and
how to Requery and set values to null if users changed their minds and
selected different values in the first two combo boxes. My problem, though,
is that when I pull down the later combo boxes, the values appear, but when I
select them, they don't actually show up in the combo box. The combo boxes
stay blank. Has anybody seen this?