Search results

  1. C

    No error if opening a form BUT VBA error if I go from Design View to Form View

    Thanks, actually the subform has no dependency on the parent. Its just setting the Combo to the value it was last set to to filter the records in the subform. I was just curious what would trigger this odd behaviour. Good point re setting it in the subform itself. Will give that a go if this...
  2. C

    No error if opening a form BUT VBA error if I go from Design View to Form View

    Thanks but why would it work simply opening the form but gives an error if open in design view first?
  3. C

    No error if opening a form BUT VBA error if I go from Design View to Form View

    I have a form with VBA on the Open event. It is setting the value of a combo box control on an embedded subform: Me.subfrmShoppingListItem.Form.cboShoppingList = Nz(GetDefaultValue(5)) This works fine whenever I open the form from scratch. HOWEVER if I place the main form in Design View and...
Top Bottom