Hi,
I have a main form with combo box "CboMonth" with sub continuous form to filter the related monthly results.
I used this code for similar criteria for another form where to filter the yearly results and this code worked fantastically but in case of months (Months Format is 10-2018, etc) , its not.
Code:
Private Sub Form_Load()
Me.CboYear.Value = CLng(Me.CboYear.Column(0, 0))
End Sub
And used for monthly form as below:
Code:
Private Sub Form_Load()
Me.CboMonth.Value = CLng(Me.CboMonth.Column(0, 0))
End Sub
and giving Run Time Error "13" mismatch type.
Seems something related to the month formats, or else?