In Access 2007, I have a form which contains the summary information of a store, and a subform which is intended to log records on employee hours for that store. The subform is supposed to display store employee names in a drop-down combo box using the store ID as a link. It's a straight link based on store ID, there is no other criteria associated with this process and the data across all the employee records (start date etc) is all complete.
For about half the stores, this works just fine - I click to record 3, it shows store C and employees X, Y and Z in the drop down in the subform. For the other half of the stores, the store information appears at the top, but I get nothing when I click in the employee name drop-down box.
As I said everything is linked up correctly and there is nothing significantly different among the stores'/employees' underlying records that should cause a discrepancy.
Has anyone run into this before? How did you resolve it?
For about half the stores, this works just fine - I click to record 3, it shows store C and employees X, Y and Z in the drop down in the subform. For the other half of the stores, the store information appears at the top, but I get nothing when I click in the employee name drop-down box.
As I said everything is linked up correctly and there is nothing significantly different among the stores'/employees' underlying records that should cause a discrepancy.
Has anyone run into this before? How did you resolve it?
