By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,509 Members | 1,710 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,509 IT Pros & Developers. It's quick & easy.

2 Combo Box's & a SubForm

P: 1
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
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,186
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.