This may verge on queries rather than forms but HELP!!!!
OK I have the following tables.
Requirements
RequirementsID 1
Junction
AgentID oo
RequirementsID oo
Agent
AgentID 1 / 1
AgentEmployee
AgentEmpID oo
What I have is a query that looks up Requirements, Junction and Agent. This works perfectly. I have based a form on said query and this works great. The Agent is a subform as there can be many agents and I can select the agent fine and dandy. What I want to do is select the Agent then in the next drop down select an Agent Employee (these agencies have hundreds and sometimes thousands of people working for them). I don't seem able to do it.
This is what I have tried....
I made a field to pick up the AgentID from the subform in the main Requirements form. (AgentIDedit) This works fine.
I then made a query...
AgentID criteria = [Forms]![Requirementsform].[AgentIDedit].
Displaying AgentEmployee name
But this doesn't work. Tried using ID's of both Agent and AgentEmployee but that didn't work either. Any help would be appreciated...
OK I have the following tables.
Requirements
RequirementsID 1
Junction
AgentID oo
RequirementsID oo
Agent
AgentID 1 / 1
AgentEmployee
AgentEmpID oo
What I have is a query that looks up Requirements, Junction and Agent. This works perfectly. I have based a form on said query and this works great. The Agent is a subform as there can be many agents and I can select the agent fine and dandy. What I want to do is select the Agent then in the next drop down select an Agent Employee (these agencies have hundreds and sometimes thousands of people working for them). I don't seem able to do it.
This is what I have tried....
I made a field to pick up the AgentID from the subform in the main Requirements form. (AgentIDedit) This works fine.
I then made a query...
AgentID criteria = [Forms]![Requirementsform].[AgentIDedit].
Displaying AgentEmployee name
But this doesn't work. Tried using ID's of both Agent and AgentEmployee but that didn't work either. Any help would be appreciated...
