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...