I have a dynamic combo box in a subform that displays different values depending on the value of a field in the main form. So if the main forms cboProductLine field says we are working on “Baseball” then the combo box on the subform gives choices like Gloves, Bats, or Rosin; if it says “Golf” then the choices on the subform combobox are Golf Bag, Putter, or Driver. My combo box Recordsource is a query that puts the current value of the main form’s cboProductLine control.
My problem is making sure the subform combobox is requeryed to get the right value under all circumstances. It works well when clicking through existing records but usually fails when a new main record is added and assigned a ProductLine. I have tried tying a Requery to the form and subform Current and the ProductLine_Change events, but get inconsisent results. (Also, Requery is not supported when a Filter is used.)
Is there a rule regarding what events to use to ensure that a dynamic combo box in a subformis updated and shows the appropriate options?
