Hi, I'm new to VBA and I thought this would be easy
. I have subform with an unbound combo box. Upon selection, the combo box populates certain text boxes on the subform. I would like the combo box that is set to a default to automatically populate the text boxes when the subform is loaded. I have the below code to fill in the combo box default using the onload event on the subform. But when the subform does load, the combo box only shows the default value and it does not fire to populate the text boxes on the subform. I need to reselect the default from the combo box to populate the text boxes. Can anyone please tell me what I'm missing.
Me.cboDestinSiteName.DefaultValue = Me.cboDestinSiteName.ItemData(10)

Me.cboDestinSiteName.DefaultValue = Me.cboDestinSiteName.ItemData(10)