467,139 Members | 1,356 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,139 developers. It's quick & easy.

2 Combo Box's & a SubForm

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 :
Expand|Select|Wrap|Line Numbers
  1. Select qrySupervisors.Supervisor
  2. 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.
Jul 30 '08 #1
  • viewed: 1140
Share:
1 Reply
NeoPa
Expert Mod 16PB
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.
Aug 5 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by BigJay | last post: by
2 posts views Thread by dancole42@gmail.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.