2 Combo Box's & a SubForm

[gsbatch1]

Relatively new to Access, 1 year of self taught.
I have a Form (Form1) that is Unbound, with the main Combo Box, (SupCombo) that has its Row Source :

Select qrySupervisors.Supervisor
From qrySupervisor

qrySupervisor 1 column
Supervisor

Once the supervisor is selected, the Second Combo Box (AgentCombo) populates with the Agents assigned to that Supervisor. AgentCombo's Row Source is "qryAgent"
qryAgent 2 Columns
Agent
Supervisor (Criteria : [Forms]![Form1]![SupCombo]) to link it to the SupCombo box.

What I want to do is have a subform that populates the relevant data to that particular Agent, time in, out, break time, etc. I want to be able to allow the supervisor to change the agent in the combo box and the subform change to that agents data.

Any Help would be appreciated.

[NeoPa]

Check out Example Filtering on a Form for a fuller explanation, but I would suggest using a filter on your subform, which can be set up in code after a selection is made from the Agent ComboBox.