I am getting a message that states you have cancelled the previous operation on the following code. The runtime error hits on FilterON = True line. This only happens when I choose DATE from my drop down list. My filter is based on the value I choose in the drop down list.
Combo25.RowSource = "Select distinct LOAD_RPT_DATE from load_rpt_YES"
ColName.Value = "LOAD_RPT_DATE"
Case "Pub ID"
Combo25.RowSource = "Select distinct PUB_ID from load_rpt_YES"
ColName.Value = "PUB_ID"