I am designing a data entry form with a subform. In the subform, I have a list box control that has an inherit value list from a lookup table. On the main form I have a combo list that I am using as a record selector that filters the record on the subform. How can I filter the list box with the values from the lookup table by the slection in the combo box of gthe main form as well.
To give this context, In the main form I have a combo box of employees. When I select one, it finds the corresponding supervisor. On the subform everything works well except the look up values are independent of the employee or supervisor. I want it to show only those goals appropriate for the employeed. I can get lots of other things to work on the subform, but not the lookup. I am using the lookup to force the slecection of goals. i do not want people typing whatever they want because we want uniformity with our agreed upon goals. any ideas? Thanks in advance!
To give this context, In the main form I have a combo box of employees. When I select one, it finds the corresponding supervisor. On the subform everything works well except the look up values are independent of the employee or supervisor. I want it to show only those goals appropriate for the employeed. I can get lots of other things to work on the subform, but not the lookup. I am using the lookup to force the slecection of goals. i do not want people typing whatever they want because we want uniformity with our agreed upon goals. any ideas? Thanks in advance!
