S
sweyer via AccessMonster.com
Okay so I have this problem with a subform requery.
My main form - Employees, Subform - EmployeePolicies. On the employee form, I
have drop-down box that shows all the different Groups that we have. When you
choose a group, the EmployeePolicies form is supposed to requery to pull up
the Policies for that Group. However, it works for the first group you choose.
If you add two employees in a row, each in a different group. The first
person is in Group A, and the second in Group B. When I select Group A for
the first person, the subform requeries fine. However, whenever I add the
second Employee and select Group B, Group A's policies come up instead. How
can I fix this?
My main form - Employees, Subform - EmployeePolicies. On the employee form, I
have drop-down box that shows all the different Groups that we have. When you
choose a group, the EmployeePolicies form is supposed to requery to pull up
the Policies for that Group. However, it works for the first group you choose.
If you add two employees in a row, each in a different group. The first
person is in Group A, and the second in Group B. When I select Group A for
the first person, the subform requeries fine. However, whenever I add the
second Employee and select Group B, Group A's policies come up instead. How
can I fix this?